View: GMS_FUNDSCTL_V

Product:	GMS - Grants Accounting
Description:	- Retrofitted - Retrofitted
Implementation/DBA Data:	APPS.GMS_FUNDSCTL_V

View Text

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

Columns