[Home] [Help]
| Product: | PA - Projects |
|---|---|
| Description: | View of projects costs including manufacturing costs. PA_PROJ_COST_SL_MRC_V shows transactions in Oracle projects by GL account. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, CDL.LINE_NUM COST_DISTRIBUTION_LINE_NUM
, CDL.DR_CODE_COMBINATION_ID CODE_COMBINATION_ID
, GLC.DESCRIPTION ACCOUNT_DESCRIPTION
, CDL.GL_DATE GL_DATE
, SYS.PROJECT_MANUFACTURING_FLAG MFG_RELATED
, SYS.MEANING SYSTEM_LINKAGE_FUNCTION
, ET.EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY
, ET.EXPENDITURE_TYPE EXPENDITURE_TYPE
, CDL.ORG_ID ORGANIZATION_ID
, PRJ.PROJECT_TYPE PROJECT_TYPE
, PRJ.PROJECT_ID PROJECT_ID
, PRJ.SEGMENT1 PROJECT_NUMBER
, PRJ.NAME PROJECT_NAME
, TASK.TASK_ID TASK_ID
, TASK.TASK_NUMBER TASK_NUMBER
, TASK.TASK_NAME TASK_NAME
, DECODE(NVL(CDL.ACCT_BURDENED_COST
, 0)
, 0
, CDL.ACCT_RAW_COST
, CDL.ACCT_BURDENED_COST) TOTAL_COST
, CDL.ACCT_RAW_COST RAW_COST
, NVL(NVL(CDL.ACCT_BURDENED_COST
, 0)
, CDL.ACCT_RAW_COST) - CDL.ACCT_RAW_COST BURDEN_COST
FROM PA_EXPENDITURE_TYPES ET
, PA_PROJECTS_ALL PRJ
, PA_TASKS TASK
, GL_CODE_COMBINATIONS GLC
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_COST_DIST_LINES_ALL_MRC_V2 CDL
, PA_SYSTEM_LINKAGES SYS
WHERE CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND CDL.LINE_TYPE = 'R'
AND EI.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
AND GLC.CODE_COMBINATION_ID = CDL.DR_CODE_COMBINATION_ID
AND EI.TASK_ID = TASK.TASK_ID
AND TASK.PROJECT_ID = PRJ.PROJECT_ID
AND CDL.TRANSFER_STATUS_CODE || '' IN ('A'
, 'V')
AND EI.SYSTEM_LINKAGE_FUNCTION = SYS.FUNCTION