View: PA_EI_DENORM_V

Product:	PA - Projects
Description:	Expenditure Item Info along with Denorm data in vertical fashion
Implementation/DBA Data:	APPS.PA_EI_DENORM_V

View Text

SELECT EXPENDITURE_ID
, EXPENDITURE_ITEM_ID
, TASK_ID
, EXPENDITURE_TYPE
, BILLABLE_FLAG
, EXPENDITURE_ITEM_DATE
, QUANTITY
, RAW_COST
, NVL(DENOM_RAW_COST
, QUANTITY*PA_UTILS.GETEXPTYPECOSTRATE(EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE))
, RECEIPT_CURRENCY_CODE
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_EXCHANGE_RATE
, UNIT_OF_MEASURE
FROM PA_EXPENDITURE_ITEMS UNION ALL SELECT EXPENDITURE_ID
, EXPENDITURE_ITEM_ID_1
, TASK_ID
, EXPENDITURE_TYPE
, BILLABLE_FLAG
, EXPENDITURE_ITEM_DATE_1
, QUANTITY_1
, RAW_COST_1
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
FROM PA_EI_DENORM
WHERE QUANTITY_1 IS NOT NULL
AND EXPENDITURE_ITEM_ID_1 IS NULL UNION ALL SELECT EXPENDITURE_ID
, EXPENDITURE_ITEM_ID_2
, TASK_ID
, EXPENDITURE_TYPE
, BILLABLE_FLAG
, EXPENDITURE_ITEM_DATE_2
, QUANTITY_2
, RAW_COST_2
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
FROM PA_EI_DENORM
WHERE QUANTITY_2 IS NOT NULL
AND EXPENDITURE_ITEM_ID_2 IS NULL UNION ALL SELECT EXPENDITURE_ID
, EXPENDITURE_ITEM_ID_3
, TASK_ID
, EXPENDITURE_TYPE
, BILLABLE_FLAG
, EXPENDITURE_ITEM_DATE_3
, QUANTITY_3
, RAW_COST_3
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
FROM PA_EI_DENORM
WHERE QUANTITY_3 IS NOT NULL
AND EXPENDITURE_ITEM_ID_3 IS NULL UNION ALL SELECT EXPENDITURE_ID
, EXPENDITURE_ITEM_ID_4
, TASK_ID
, EXPENDITURE_TYPE
, BILLABLE_FLAG
, EXPENDITURE_ITEM_DATE_4
, QUANTITY_4
, RAW_COST_4
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
FROM PA_EI_DENORM
WHERE QUANTITY_4 IS NOT NULL
AND EXPENDITURE_ITEM_ID_4 IS NULL UNION ALL SELECT EXPENDITURE_ID
, EXPENDITURE_ITEM_ID_5
, TASK_ID
, EXPENDITURE_TYPE
, BILLABLE_FLAG
, EXPENDITURE_ITEM_DATE_5
, QUANTITY_5
, RAW_COST_5
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
FROM PA_EI_DENORM
WHERE QUANTITY_5 IS NOT NULL
AND EXPENDITURE_ITEM_ID_5 IS NULL UNION ALL SELECT EXPENDITURE_ID
, EXPENDITURE_ITEM_ID_6
, TASK_ID
, EXPENDITURE_TYPE
, BILLABLE_FLAG
, EXPENDITURE_ITEM_DATE_6
, QUANTITY_6
, RAW_COST_6
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
FROM PA_EI_DENORM
WHERE QUANTITY_6 IS NOT NULL
AND EXPENDITURE_ITEM_ID_6 IS NULL UNION ALL SELECT EXPENDITURE_ID
, EXPENDITURE_ITEM_ID_7
, TASK_ID
, EXPENDITURE_TYPE
, BILLABLE_FLAG
, EXPENDITURE_ITEM_DATE_7
, QUANTITY_7
, RAW_COST_7
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
FROM PA_EI_DENORM
WHERE QUANTITY_7 IS NOT NULL
AND EXPENDITURE_ITEM_ID_7 IS NULL

Columns