VIEW: APPS.GMS_FUNDSCTL_V

Source

View Text - Preformatted

SELECT BC.PACKET_ID PACKET_ID , BC.PROJECT_ID PROJECT_ID , AW.AWARD_ID AWARD_ID , BC.TASK_ID TASK_ID , BC.TOP_TASK_ID TOP_TASK_ID , BC.EXPENDITURE_TYPE EXPENDITURE_TYPE , BC.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE , BC.ACTUAL_FLAG ACTUAL_FLAG , BC.STATUS_CODE GMS_STATUS_CODE, L1.MEANING GMS_STATUS_CODE_MEANING, BC.JE_CATEGORY_NAME JE_CATEGORY_NAME , BC.JE_SOURCE_NAME JE_SOURCE_NAME , L2.MEANING DOCUMENT_TYPE , BC.DOCUMENT_TYPE BCPKT_DOCUMENT_TYPE, BC.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID , BC.PERIOD_NAME PERIOD_NAME , BC.PERIOD_YEAR PERIOD_YEAR , BC.PERIOD_NUM PERIOD_NUM , BC.DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID , BC.DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID , BC.BUDGET_VERSION_ID BUDGET_VERSION_ID , BC.ACCOUNT_TYPE ACCOUNT_TYPE , NVL(BC.ENTERED_DR,0)-NVL(BC.ENTERED_CR,0) AMOUNT , BC.EFFECT_ON_FUNDS_CODE EFFECT_ON_FUNDS_CODE , BC.RESULT_CODE RESULT_CODE , BC.BALANCE_POSTED_FLAG BALANCE_POSTED_FLAG , BC.BURDEN_POSTED_FLAG BURDEN_POSTED_FLAG , BC.GL_BC_PACKETS_ROWID GL_ROW_ID , PR.SEGMENT1 PROJECT , TA.TASK_NUMBER TASK , AW.AWARD_NUMBER AWARD_NUMBER , GBV.VERSION_NAME VERSION_NAME , DECODE(GBV.BUDGET_STATUS_CODE,'B','Baselined','S','Submitted','W','Working')BUDGET_STATUS_CODE , BC.BC_PACKET_ID, BC.FUNDS_CHECK_SEQ , BC.REQUEST_ID, BC.BURDEN_ADJUSTMENT_FLAG, BC.BURDEN_ADJ_BC_PACKET_ID , AW.ORG_ID , BC.SOURCE_EVENT_ID FROM PA_PROJECTS_ALL PR , PA_TASKS TA , GMS_AWARDS AW , gms_project_types gpt, GMS_BUDGET_VERSIONS GBV , GMS_LOOKUPS L1, GMS_LOOKUPS L2, GMS_BC_PACKETS BC WHERE BC.PROJECT_ID = PR.PROJECT_ID AND BC.TASK_ID = TA.TASK_ID AND BC.AWARD_ID = AW.AWARD_ID AND BC.BUDGET_VERSION_ID = GBV.BUDGET_VERSION_ID AND GBV.CURRENT_FLAG = 'Y' AND PR.PROJECT_TYPE = GPT.PROJECT_TYPE AND GPT.SPONSORED_FLAG = 'Y' and L1.LOOKUP_TYPE = 'GMS_STATUS_CODE' and L1.LOOKUP_CODE = BC.STATUS_CODE and L2.LOOKUP_TYPE = 'GMS_DOCUMENT_TYPE' and L2.LOOKUP_CODE = BC.DOCUMENT_TYPE UNION ALL SELECT BC.PACKET_ID PACKET_ID , BC.PROJECT_ID PROJECT_ID , imp.default_dist_award_id AWARD_ID , BC.TASK_ID TASK_ID , BC.TOP_TASK_ID TOP_TASK_ID , BC.EXPENDITURE_TYPE EXPENDITURE_TYPE , BC.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE , BC.ACTUAL_FLAG ACTUAL_FLAG , BC.STATUS_CODE GMS_STATUS_CODE, L1.MEANING GMS_STATUS_CODE_MEANING, BC.JE_CATEGORY_NAME JE_CATEGORY_NAME , BC.JE_SOURCE_NAME JE_SOURCE_NAME , L2.MEANING DOCUMENT_TYPE , BC.DOCUMENT_TYPE BCPKT_DOCUMENT_TYPE, BC.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID , BC.PERIOD_NAME PERIOD_NAME , BC.PERIOD_YEAR PERIOD_YEAR , BC.PERIOD_NUM PERIOD_NUM , BC.DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID , BC.DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID , BC.BUDGET_VERSION_ID BUDGET_VERSION_ID , BC.ACCOUNT_TYPE ACCOUNT_TYPE , NVL(BC.ENTERED_DR,0) - NVL(BC.ENTERED_CR,0) AMOUNT , BC.EFFECT_ON_FUNDS_CODE EFFECT_ON_FUNDS_CODE , BC.RESULT_CODE RESULT_CODE , BC.BALANCE_POSTED_FLAG BALANCE_POSTED_FLAG , BC.BURDEN_POSTED_FLAG BURDEN_POSTED_FLAG , BC.GL_BC_PACKETS_ROWID GL_ROW_ID , PR.SEGMENT1 PROJECT , TA.TASK_NUMBER TASK , imp.default_dist_award_number AWARD_NUMBER , NULL VERSION_NAME , NULL BUDGET_STATUS_CODE , BC.BC_PACKET_ID, BC.FUNDS_CHECK_SEQ , BC.REQUEST_ID, BC.BURDEN_ADJUSTMENT_FLAG, BC.BURDEN_ADJ_BC_PACKET_ID , IMP.ORG_ID , BC.SOURCE_EVENT_ID FROM PA_PROJECTS_ALL PR , PA_TASKS TA , gms_implementations imp, gms_project_types gpt, GMS_LOOKUPS L1, GMS_LOOKUPS L2, GMS_BC_PACKETS BC WHERE BC.PROJECT_ID = PR.PROJECT_ID AND BC.TASK_ID = TA.TASK_ID AND BC.AWARD_ID = IMP.DEFAULT_DIST_AWARD_ID AND PR.PROJECT_TYPE = GPT.PROJECT_TYPE AND GPT.SPONSORED_FLAG = 'Y' and L1.LOOKUP_TYPE = 'GMS_STATUS_CODE' and L1.LOOKUP_CODE = BC.STATUS_CODE and L2.LOOKUP_TYPE = 'GMS_DOCUMENT_TYPE' and L2.LOOKUP_CODE = BC.DOCUMENT_TYPE

View Text - HTML Formatted

SELECT BC.PACKET_ID PACKET_ID
, BC.PROJECT_ID PROJECT_ID
, AW.AWARD_ID AWARD_ID
, BC.TASK_ID TASK_ID
, BC.TOP_TASK_ID TOP_TASK_ID
, BC.EXPENDITURE_TYPE EXPENDITURE_TYPE
, BC.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, BC.ACTUAL_FLAG ACTUAL_FLAG
, BC.STATUS_CODE GMS_STATUS_CODE
, L1.MEANING GMS_STATUS_CODE_MEANING
, BC.JE_CATEGORY_NAME JE_CATEGORY_NAME
, BC.JE_SOURCE_NAME JE_SOURCE_NAME
, L2.MEANING DOCUMENT_TYPE
, BC.DOCUMENT_TYPE BCPKT_DOCUMENT_TYPE
, BC.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, BC.PERIOD_NAME PERIOD_NAME
, BC.PERIOD_YEAR PERIOD_YEAR
, BC.PERIOD_NUM PERIOD_NUM
, BC.DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID
, BC.DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID
, BC.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BC.ACCOUNT_TYPE ACCOUNT_TYPE
, NVL(BC.ENTERED_DR
, 0)-NVL(BC.ENTERED_CR
, 0) AMOUNT
, BC.EFFECT_ON_FUNDS_CODE EFFECT_ON_FUNDS_CODE
, BC.RESULT_CODE RESULT_CODE
, BC.BALANCE_POSTED_FLAG BALANCE_POSTED_FLAG
, BC.BURDEN_POSTED_FLAG BURDEN_POSTED_FLAG
, BC.GL_BC_PACKETS_ROWID GL_ROW_ID
, PR.SEGMENT1 PROJECT
, TA.TASK_NUMBER TASK
, AW.AWARD_NUMBER AWARD_NUMBER
, GBV.VERSION_NAME VERSION_NAME
, DECODE(GBV.BUDGET_STATUS_CODE
, 'B'
, 'BASELINED'
, 'S'
, 'SUBMITTED'
, 'W'
, 'WORKING')BUDGET_STATUS_CODE
, BC.BC_PACKET_ID
, BC.FUNDS_CHECK_SEQ
, BC.REQUEST_ID
, BC.BURDEN_ADJUSTMENT_FLAG
, BC.BURDEN_ADJ_BC_PACKET_ID
, AW.ORG_ID
, BC.SOURCE_EVENT_ID
FROM PA_PROJECTS_ALL PR
, PA_TASKS TA
, GMS_AWARDS AW
, GMS_PROJECT_TYPES GPT
, GMS_BUDGET_VERSIONS GBV
, GMS_LOOKUPS L1
, GMS_LOOKUPS L2
, GMS_BC_PACKETS BC
WHERE BC.PROJECT_ID = PR.PROJECT_ID
AND BC.TASK_ID = TA.TASK_ID
AND BC.AWARD_ID = AW.AWARD_ID
AND BC.BUDGET_VERSION_ID = GBV.BUDGET_VERSION_ID
AND GBV.CURRENT_FLAG = 'Y'
AND PR.PROJECT_TYPE = GPT.PROJECT_TYPE
AND GPT.SPONSORED_FLAG = 'Y'
AND L1.LOOKUP_TYPE = 'GMS_STATUS_CODE'
AND L1.LOOKUP_CODE = BC.STATUS_CODE
AND L2.LOOKUP_TYPE = 'GMS_DOCUMENT_TYPE'
AND L2.LOOKUP_CODE = BC.DOCUMENT_TYPE UNION ALL SELECT BC.PACKET_ID PACKET_ID
, BC.PROJECT_ID PROJECT_ID
, IMP.DEFAULT_DIST_AWARD_ID AWARD_ID
, BC.TASK_ID TASK_ID
, BC.TOP_TASK_ID TOP_TASK_ID
, BC.EXPENDITURE_TYPE EXPENDITURE_TYPE
, BC.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, BC.ACTUAL_FLAG ACTUAL_FLAG
, BC.STATUS_CODE GMS_STATUS_CODE
, L1.MEANING GMS_STATUS_CODE_MEANING
, BC.JE_CATEGORY_NAME JE_CATEGORY_NAME
, BC.JE_SOURCE_NAME JE_SOURCE_NAME
, L2.MEANING DOCUMENT_TYPE
, BC.DOCUMENT_TYPE BCPKT_DOCUMENT_TYPE
, BC.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, BC.PERIOD_NAME PERIOD_NAME
, BC.PERIOD_YEAR PERIOD_YEAR
, BC.PERIOD_NUM PERIOD_NUM
, BC.DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID
, BC.DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID
, BC.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BC.ACCOUNT_TYPE ACCOUNT_TYPE
, NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0) AMOUNT
, BC.EFFECT_ON_FUNDS_CODE EFFECT_ON_FUNDS_CODE
, BC.RESULT_CODE RESULT_CODE
, BC.BALANCE_POSTED_FLAG BALANCE_POSTED_FLAG
, BC.BURDEN_POSTED_FLAG BURDEN_POSTED_FLAG
, BC.GL_BC_PACKETS_ROWID GL_ROW_ID
, PR.SEGMENT1 PROJECT
, TA.TASK_NUMBER TASK
, IMP.DEFAULT_DIST_AWARD_NUMBER AWARD_NUMBER
, NULL VERSION_NAME
, NULL BUDGET_STATUS_CODE
, BC.BC_PACKET_ID
, BC.FUNDS_CHECK_SEQ
, BC.REQUEST_ID
, BC.BURDEN_ADJUSTMENT_FLAG
, BC.BURDEN_ADJ_BC_PACKET_ID
, IMP.ORG_ID
, BC.SOURCE_EVENT_ID
FROM PA_PROJECTS_ALL PR
, PA_TASKS TA
, GMS_IMPLEMENTATIONS IMP
, GMS_PROJECT_TYPES GPT
, GMS_LOOKUPS L1
, GMS_LOOKUPS L2
, GMS_BC_PACKETS BC
WHERE BC.PROJECT_ID = PR.PROJECT_ID
AND BC.TASK_ID = TA.TASK_ID
AND BC.AWARD_ID = IMP.DEFAULT_DIST_AWARD_ID
AND PR.PROJECT_TYPE = GPT.PROJECT_TYPE
AND GPT.SPONSORED_FLAG = 'Y'
AND L1.LOOKUP_TYPE = 'GMS_STATUS_CODE'
AND L1.LOOKUP_CODE = BC.STATUS_CODE
AND L2.LOOKUP_TYPE = 'GMS_DOCUMENT_TYPE'
AND L2.LOOKUP_CODE = BC.DOCUMENT_TYPE