eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_TRX_FUNDS_CHK_DET_V

Source

View Text - Preformatted


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_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 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

View Text - HTML Formatted

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_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 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