VIEW: APPS.GMS_1034_REPORT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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