View: GMS_COMMITMENT_BURDEN_V

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

View Text

SELECT DOCUMENT_TYPE
, TRANSACTION_SOURCE
, CMT_NUMBER
, DESCRIPTION
, PROJECT_ID
, TASK_ID
, AWARD_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, ORGANIZATION_ID
, VENDOR_NAME
, UNIT_OF_MEASURE
, UNIT_PRICE
, PA_PERIOD
, SUM(TOT_CMT_QUANTITY) TOT_CMT_QUANTITY
, SUM(ACCT_RAW_COST) ACCT_RAW_COST
, SUM(ACCT_BURDENED_COST) ACCT_BURDENED_COST
, GL_DATE
FROM ( SELECT DOCUMENT_TYPE
, TRANSACTION_SOURCE
, CMT_NUMBER
, DESCRIPTION
, PROJECT_ID
, TASK_ID
, AWARD_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, ORGANIZATION_ID
, VENDOR_NAME
, UNIT_OF_MEASURE
, UNIT_PRICE
, PA_PERIOD
, TOT_CMT_QUANTITY
, ACCT_RAW_COST
, ACCT_RAW_COST ACCT_BURDENED_COST
, GL_DATE
FROM GMS_COMMITMENT_ENCUMBERED_V UNION ALL SELECT CMT.DOCUMENT_TYPE
, CMT.TRANSACTION_SOURCE
, CMT.CMT_NUMBER
, CMT.DESCRIPTION
, CMT.PROJECT_ID
, CMT.TASK_ID
, CMT.AWARD_ID
, ICC.EXPENDITURE_TYPE
, CMT.EXPENDITURE_ITEM_DATE
, CMT.ORGANIZATION_ID
, CMT.VENDOR_NAME
, CMT.UNIT_OF_MEASURE
, CMT.UNIT_PRICE
, CMT.PA_PERIOD
, 0
, 0
, NVL (CMT.BURDENABLE_RAW_COST
, 0) * CM.COMPILED_MULTIPLIER ACCT_BURDENED_COST
, CMT.GL_DATE
FROM PA_IND_COST_CODES ICC
, PA_COST_BASE_EXP_TYPES CBET
, PA_COMPILED_MULTIPLIERS CM
, GMS_COMMITMENT_ENCUMBERED_V CMT
WHERE ICC.IND_COST_CODE = CM.IND_COST_CODE
AND CBET.COST_BASE = CM.COST_BASE
AND CBET.COST_BASE_TYPE = 'INDIRECT COST'
AND CBET.EXPENDITURE_TYPE = CMT.EXPENDITURE_TYPE
AND CM.IND_COMPILED_SET_ID = CMT.IND_COMPILED_SET_ID
AND CMT.BURDENABLE_RAW_COST <> 0
AND CMT.IND_COMPILED_SET_ID IS NOT NULL
AND CMT.BURDENABLE_RAW_COST * CM.COMPILED_MULTIPLIER <> 0
AND EXISTS ( SELECT NULL FROM PA_IND_RATE_SCH_REVISIONS IRSR WHERE IRSR.COST_PLUS_STRUCTURE = CBET.COST_PLUS_STRUCTURE AND EXISTS (SELECT NULL FROM PA_IND_COMPILED_SETS ICS WHERE ICS.COST_BASE = CBET.COST_BASE AND ICS.IND_RATE_SCH_REVISION_ID = IRSR.IND_RATE_SCH_REVISION_ID AND ICS.ORGANIZATION_ID = CMT.ORGANIZATION_ID AND ICS.IND_COMPILED_SET_ID = CMT.IND_COMPILED_SET_ID ))) GROUP BY DOCUMENT_TYPE
, TRANSACTION_SOURCE
, CMT_NUMBER
, DESCRIPTION
, PROJECT_ID
, TASK_ID
, AWARD_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, ORGANIZATION_ID
, VENDOR_NAME
, UNIT_OF_MEASURE
, UNIT_PRICE
, PA_PERIOD
, GL_DATE

Columns