Product: | PA - Projects |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | Not implemented in this database |
SELECT EIA.PROJECT_ID
, EIA.TASK_ID
, EIA.PA_PERIOD
, PA_PER.START_DATE
, PA_PER.END_DATE
, EIA.GL_PERIOD
, GL_PER.START_DATE
, GL_PER.END_DATE
, EIA.EXPENDITURE_TYPE
, EIA.EXPENDITURE_CATEGORY
, EIA.REVENUE_CATEGORY
, EIA.EXPENDITURE_ORGANIZATION_ID
, 'EXPENDITURE ITEMS'
, NVL(EIA.TOTAL_REVENUE
, 0)
, NVL(EIA.TOTAL_RAW_COST
, 0)
, NVL(EIA.TOTAL_BURDEN_COST
, 0)
, NVL(EIA.TOTAL_QUANTITY
, 0)
, DECODE(ES.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, NVL(EIA.TOTAL_QUANTITY
, 0)
, 'OT'
, NVL(EIA.TOTAL_QUANTITY
, 0)
, 0)
, NVL(EIA.BILLABLE_RAW_COST
, 0)
, NVL(EIA.BILLABLE_BURDEN_COST
, 0)
, NVL(EIA.BILLABLE_QUANTITY
, 0)
, DECODE(ES.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, NVL(EIA.BILLABLE_QUANTITY
, 0)
, 'OT'
, NVL(EIA.BILLABLE_QUANTITY
, 0)
, 0)
, 0
, 0
, 0
FROM PA_IMPLEMENTATIONS IMP
, GL_PERIOD_STATUSES GL_PER
, PA_PERIODS PA_PER
, PA_EXPEND_TYP_SYS_LINKS ES
, PA_PROJECT_EXP_ITEM_ACCUM EIA
WHERE ES.EXPENDITURE_TYPE = EIA.EXPENDITURE_TYPE
AND ES.SYSTEM_LINKAGE_FUNCTION = EIA.SYSTEM_LINKAGE_FUNCTION
AND GL_PER.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID
AND GL_PER.APPLICATION_ID = 101
AND GL_PER.ADJUSTMENT_PERIOD_FLAG = 'N'
AND GL_PER.PERIOD_NAME = EIA.GL_PERIOD||''
AND PA_PER.PERIOD_NAME = EIA.PA_PERIOD UNION SELECT EA.PROJECT_ID
, EA.TASK_ID
, EA.PA_PERIOD
, PA_PER.START_DATE
, PA_PER.END_DATE
, EA.GL_PERIOD
, GL_PER.START_DATE
, GL_PER.END_DATE
, EA.EVENT_TYPE
, EA.REVENUE_CATEGORY_CODE
, EA.REVENUE_CATEGORY_CODE
, EA.ORGANIZATION_ID
, 'EVENTS'
, ROUND(NVL(TOTAL_REVENUE
, 0))
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PA_IMPLEMENTATIONS IMP
, GL_PERIOD_STATUSES GL_PER
, PA_PERIODS PA_PER
, PA_PROJECT_EVENT_ACCUM EA
WHERE GL_PER.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID
AND GL_PER.APPLICATION_ID = 101
AND GL_PER.ADJUSTMENT_PERIOD_FLAG = 'N'
AND GL_PER.PERIOD_NAME = EA.GL_PERIOD||''
AND PA_PER.PERIOD_NAME = EA.PA_PERIOD