Technology Stack - EBS (MOSC)

MOSC Banner

Can any one tell joins between eAM and Project accounting modules

edited Aug 20, 2021 11:02AM in Technology Stack - EBS (MOSC) Question

Hi Team,

Can any help on joins between eAM modules and project accounting modules

      PA.PA_PERIODS_ALL PAP,
PA.PA_PROJECT_TYPES_ALL PRJT,
PA.PA_EXPENDITURE_BATCHES_ALL EXPB,
PA.PA_EXPENDITURES_ALL EXP,
PA.PA_COST_DISTRIBUTION_LINES_ALL CDIST,
PA.PA_EXPENDITURE_ITEMS_ALL EXPI,
PA.PA_TASKS TASK,
PA.PA_PROJECTS_ALL PROJ

WIP.WIP_DISCRETE_JOBS DJOB        ------ this table we have join for  both projects and work orders but  PROJECT_ID and TASK_ID columns  having null values entire table  both the columns .
WIP.WIP_ENTITIES WORD ------  work order
WIP.WIP_OPERATIONS OPRN          ----- work order task

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center