Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_TRX_FUNDS_CHK_DET_V |
SELECT BC.ROWID
, BC.PACKET_ID
, BC.BC_PACKET_ID
, BC.PARENT_BC_PACKET_ID
, BC.REQUEST_ID
, BC.PROJECT_ID
, BC.TASK_ID
, BC.TOP_TASK_ID
, BC.BUDGET_CCID
, BC.EXPENDITURE_TYPE
, BC.EXPENDITURE_ITEM_DATE
, BC.ACTUAL_FLAG
, BC.STATUS_CODE
, BC.SET_OF_BOOKS_ID
, BC.JE_CATEGORY_NAME
, BC.JE_SOURCE_NAME
, BC.DOCUMENT_TYPE
, BC.EXPENDITURE_ORGANIZATION_ID
, BC.PERIOD_NAME
, BC.PERIOD_YEAR
, BC.PERIOD_NUM
, BC.DOCUMENT_HEADER_ID
, BC.DOCUMENT_DISTRIBUTION_ID
, BC.BUDGET_VERSION_ID
, NVL(BC.ACCOUNTED_DR
, 0)
, NVL(BC.ACCOUNTED_CR
, 0)
, BC.EFFECT_ON_FUNDS_CODE
, BC.RESULT_CODE
, BC.GL_ROW_NUMBER
, BC.RESOURCE_LIST_MEMBER_ID
, BC.PARENT_RESOURCE_ID
, BC.BUD_RESOURCE_LIST_MEMBER_ID
, BC.BUD_TASK_ID
, BC.R_FUNDS_CONTROL_LEVEL_CODE
, BC.RG_FUNDS_CONTROL_LEVEL_CODE
, BC.T_FUNDS_CONTROL_LEVEL_CODE
, BC.TT_FUNDS_CONTROL_LEVEL_CODE
, BC.P_FUNDS_CONTROL_LEVEL_CODE
, NVL(BC.PROJECT_BUDGET_POSTED
, 0)
, NVL(BC.PROJECT_BUDGET_POSTED
, 0)
, NVL(BC.PROJECT_ENC_POSTED
, 0)
, NVL(BC.PROJECT_ENC_APPROVED
, 0)
, NVL(BC.PROJECT_ENC_POSTED
, 0) +NVL(BC.PROJECT_ENC_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'E'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, NVL(BC.PROJECT_ACTUAL_POSTED
, 0)
, NVL(BC.PROJECT_ACTUAL_APPROVED
, 0)
, NVL(BC.PROJECT_ACTUAL_POSTED
, 0) +NVL(BC.PROJECT_ACTUAL_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'A'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, BC.PROJECT_RESULT_CODE
, NVL(BC.TOP_TASK_BUDGET_POSTED
, 0)
, NVL(BC.TOP_TASK_BUDGET_POSTED
, 0)
, NVL(BC.TOP_TASK_ENC_POSTED
, 0)
, NVL(BC.TOP_TASK_ENC_APPROVED
, 0)
, NVL(BC.TOP_TASK_ENC_POSTED
, 0) +NVL(BC.TOP_TASK_ENC_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'E'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, NVL(BC.TOP_TASK_ACTUAL_POSTED
, 0)
, NVL(BC.TOP_TASK_ACTUAL_APPROVED
, 0)
, NVL(BC.TOP_TASK_ACTUAL_POSTED
, 0) +NVL(BC.TOP_TASK_ACTUAL_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'A'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, BC.TOP_TASK_RESULT_CODE
, NVL(BC.TASK_BUDGET_POSTED
, 0)
, NVL(BC.TASK_BUDGET_POSTED
, 0)
, NVL(BC.TASK_ENC_POSTED
, 0)
, NVL(BC.TASK_ENC_APPROVED
, 0)
, NVL(BC.TASK_ENC_POSTED
, 0) +NVL(BC.TASK_ENC_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'E'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, NVL(BC.TASK_ACTUAL_POSTED
, 0)
, NVL(BC.TASK_ACTUAL_APPROVED
, 0)
, NVL(BC.TASK_ACTUAL_POSTED
, 0) +NVL(BC.TASK_ACTUAL_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'A'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, BC.TASK_RESULT_CODE
, NVL(BC.RES_GRP_BUDGET_POSTED
, 0)
, NVL(BC.RES_GRP_BUDGET_POSTED
, 0)
, NVL(BC.RES_GRP_ENC_POSTED
, 0)
, NVL(BC.RES_GRP_ENC_APPROVED
, 0)
, NVL(BC.RES_GRP_ENC_POSTED
, 0) +NVL(BC.RES_GRP_ENC_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'E'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, NVL(BC.RES_GRP_ACTUAL_POSTED
, 0)
, NVL(BC.RES_GRP_ACTUAL_APPROVED
, 0)
, NVL(BC.RES_GRP_ACTUAL_POSTED
, 0) +NVL(BC.RES_GRP_ACTUAL_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'A'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, BC.RES_GRP_RESULT_CODE
, NVL(BC.RES_BUDGET_POSTED
, 0)
, NVL(BC.RES_BUDGET_POSTED
, 0)
, NVL(BC.RES_ENC_POSTED
, 0)
, NVL(BC.RES_ENC_APPROVED
, 0)
, NVL(BC.RES_ENC_POSTED
, 0) +NVL(BC.RES_ENC_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'E'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, NVL(BC.RES_ACTUAL_POSTED
, 0)
, NVL(BC.RES_ACTUAL_APPROVED
, 0)
, NVL(BC.RES_ACTUAL_POSTED
, 0) +NVL(BC.RES_ACTUAL_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'A'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, BC.RES_RESULT_CODE
, NVL(BC.PROJECT_BUDGET_POSTED
, 0)-NVL(BC.PROJECT_ACTUAL_POSTED
, 0)- NVL(BC.PROJECT_ENC_POSTED
, 0)
, NVL(BC.TOP_TASK_BUDGET_POSTED
, 0)-NVL(BC.TOP_TASK_ACTUAL_POSTED
, 0)- NVL(BC.TOP_TASK_ENC_POSTED
, 0)
, NVL(BC.TASK_BUDGET_POSTED
, 0)-NVL(BC.TASK_ACTUAL_POSTED
, 0)- NVL(BC.TASK_ENC_POSTED
, 0)
, NVL(BC.RES_BUDGET_POSTED
, 0)-NVL(BC.RES_ACTUAL_POSTED
, 0)- NVL(BC.RES_ENC_POSTED
, 0)
, NVL(BC.RES_GRP_BUDGET_POSTED
, 0)-NVL(BC.RES_GRP_ACTUAL_POSTED
, 0)- NVL(BC.RES_GRP_ENC_POSTED
, 0)
, NVL(BC.PROJECT_BUDGET_POSTED
, 0) -NVL(BC.PROJECT_ACTUAL_POSTED
, 0) - NVL(BC.PROJECT_ENC_POSTED
, 0) -NVL(BC.PROJECT_ACTUAL_APPROVED
, 0) -NVL(BC.PROJECT_ENC_APPROVED
, 0) - (NVL(ACCOUNTED_DR
, 0) -NVL(ACCOUNTED_CR
, 0))
, NVL(BC.TASK_BUDGET_POSTED
, 0) -NVL(BC.TASK_ACTUAL_POSTED
, 0) - NVL(BC.TASK_ENC_POSTED
, 0) -NVL(BC.TASK_ACTUAL_APPROVED
, 0) -NVL(BC.TASK_ENC_APPROVED
, 0) - (NVL(ACCOUNTED_DR
, 0) -NVL(ACCOUNTED_CR
, 0))
, NVL(BC.TOP_TASK_BUDGET_POSTED
, 0) -NVL(BC.TOP_TASK_ACTUAL_POSTED
, 0) - NVL(BC.TOP_TASK_ENC_POSTED
, 0) -NVL(BC.TOP_TASK_ACTUAL_APPROVED
, 0) - NVL(BC.TOP_TASK_ENC_APPROVED
, 0) - (NVL(ACCOUNTED_DR
, 0) -NVL(ACCOUNTED_CR
, 0))
, NVL(BC.RES_BUDGET_POSTED
, 0) -NVL(BC.RES_ACTUAL_POSTED
, 0) - NVL(BC.RES_ENC_POSTED
, 0) -NVL(BC.RES_ACTUAL_APPROVED
, 0) - NVL(BC.RES_ENC_APPROVED
, 0) - (NVL(ACCOUNTED_DR
, 0) -NVL(ACCOUNTED_CR
, 0))
, NVL(BC.RES_GRP_BUDGET_POSTED
, 0) -NVL(BC.RES_GRP_ACTUAL_POSTED
, 0) -NVL(BC.RES_GRP_ENC_POSTED
, 0) -NVL(BC.RES_GRP_ACTUAL_APPROVED
, 0) -NVL(BC.RES_GRP_ENC_APPROVED
, 0) - (NVL(ACCOUNTED_DR
, 0) -NVL(ACCOUNTED_CR
, 0))
, PR.SEGMENT1
, TA.TASK_NUMBER
, BV.VERSION_NAME
, L1.MEANING
, L2.MEANING
, L3.MEANING
, L4.MEANING
, L5.MEANING
, L6.MEANING
FROM PA_OPERATING_UNITS_V PO
, PA_BC_PACKETS BC
, PA_PROJECTS_ALL PR
, PA_TASKS TA
, PA_LOOKUPS L1
, PA_LOOKUPS L2
, PA_LOOKUPS L3
, PA_LOOKUPS L4
, PA_LOOKUPS L5
, PA_LOOKUPS L6
, PA_BUDGET_VERSIONS BV
WHERE BC.PROJECT_ID = PR.PROJECT_ID
AND PR.ORG_ID = PO.ORG_ID
AND BC.TASK_ID = TA.TASK_ID
AND BV.BUDGET_VERSION_ID(+) = BC.BUDGET_VERSION_ID
AND L1.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L1.LOOKUP_CODE(+) = BC.RESULT_CODE
AND L2.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L2.LOOKUP_CODE(+) = BC.PROJECT_RESULT_CODE
AND L3.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L3.LOOKUP_CODE(+) = BC.TASK_RESULT_CODE
AND L4.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L4.LOOKUP_CODE(+) = BC.RES_RESULT_CODE
AND L5.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L5.LOOKUP_CODE(+) = BC.RES_GRP_RESULT_CODE
AND L6.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L6.LOOKUP_CODE(+) = BC.TOP_TASK_RESULT_CODE