VIEW: APPS.PA_EI_DENORM_V

Source

View Text - Preformatted

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_ALL 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

View Text - HTML Formatted

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_ALL 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