View: GMS_1034_REPORT_V

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

View Text

SELECT GDIL.BILL_AMOUNT CATEGORY_AMOUNT
, GDIL.EXPENDITURE_TYPE
, GDIL.EXPENDITURE_ITEM_ID
, PEC.EXPENDITURE_CATEGORY
, PEC.DESCRIPTION
, GDIL.PROJECT_ID
, 'Y' REPORT_DIRECT_FLAG
, GDIL.DRAFT_INVOICE_NUM
FROM GMS_DRAFT_INV_LINE_DETAILS_V GDIL
, PA_EXPENDITURE_CATEGORIES PEC
, PA_EXPENDITURE_TYPES PET
WHERE GDIL.EXPENDITURE_TYPE = PET.EXPENDITURE_TYPE
AND PET.EXPENDITURE_CATEGORY = PEC.EXPENDITURE_CATEGORY
AND NOT EXISTS ( SELECT 1
FROM PA_IND_COST_CODES ICC
WHERE ICC.EXPENDITURE_TYPE = GDIL.EXPENDITURE_TYPE) UNION SELECT GDIL.BURDEN_COST CATEGORY_AMOUNT
, GDIL.EXPENDITURE_TYPE
, GDIL.EXPENDITURE_ITEM_ID
, GDIL.EXPENDITURE_TYPE
, PICC.DESCRIPTION
, PROJECT_ID
, NVL( GICC.REPORT_DIRECT_FLAG
, 'N')
, GDIL.DRAFT_INVOICE_NUM
FROM GMS_DRAFT_INV_LINE_DETAILS_V GDIL
, GMS_IND_COST_CODES GICC
, PA_IND_COST_CODES PICC
WHERE PICC.IND_COST_CODE = GDIL.ORIG_TRANSACTION_REFERENCE
AND PICC.EXPENDITURE_TYPE = GDIL.EXPENDITURE_TYPE
AND GICC.IND_COST_CODE(+) = PICC.IND_COST_CODE

Columns