[Home] [Help]
View: PA_COMMITMENT_TXNS_V
View Text
SELECT
PPRD.PROJECT_ID
, PPRD.TASK_ID
, 'ORACLE_PURCHASING'
, 'R'
, PPRD.REQ_NUMBER
, PPRD.REQ_DISTRIBUTION_ID
, PPRD.REQUISITION_HEADER_ID
, PPRD.ITEM_DESCRIPTION
, PPRD.EXPENDITURE_ITEM_DATE
, NULL
, NULL
, PPRD.REQ_LINE
, PPRD.CREATION_DATE
, TO_DATE(NULL)
, PPRD.REQUESTOR_NAME
, TO_CHAR(NULL)
, PPRD.APPROVED_FLAG
, TO_DATE(NULL)
, PPRD.NEED_BY_DATE
, PPRD.EXPENDITURE_ORGANIZATION_ID
, PPRD.VENDOR_ID
, PPRD.VENDOR_NAME
, PPRD.EXPENDITURE_TYPE
, PPRD.EXPENDITURE_CATEGORY
, PPRD.REVENUE_CATEGORY
, 'VI'
, PPRD.UNIT
, PPRD.UNIT_PRICE
, PA_BURDEN_CMTS.GET_CMT_COMPILED_SET_ID(NULL
, 'CMT'
, PPRD.TASK_ID
,
PPRD.EXPENDITURE_ITEM_DATE
, PPRD.EXPENDITURE_ORGANIZATION_ID
, PPRD.EXPENDITURE_TYPE
, 'C')
, PPRD.AMOUNT
+ JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'R'
, PPRD.REQUISITION_HEADER_ID
, PPRD.REQ_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR
, PPRD.UNIT
, PPRD.QUANTITY
, PPRD.ACCT_EXCHANGE_RATE) /* 6012567 */
, PA_BURDEN_CMTS.GET_CMT_BURDENED_COST(NULL
, 'CMT'
, PPRD.TASK_ID
,
PPRD.EXPENDITURE_ITEM_DATE
, PPRD.EXPENDITURE_TYPE
,
PPRD.EXPENDITURE_ORGANIZATION_ID
, 'C'
, PPRD.AMOUNT
+ JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'R'
, PPRD.REQUISITION_HEADER_ID
, PPRD.REQ_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR
, PPRD.UNIT
, PPRD.QUANTITY
, PPRD.ACCT_EXCHANGE_RATE) /*6012567*/
)
, PPRD.QUANTITY
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, SYSDATE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, PPRD.DENOM_CURRENCY_CODE
, PPRD.DENOM_AMOUNT
+ JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'R'
, PPRD.REQUISITION_HEADER_ID
, PPRD.REQ_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_TRX_CURR_INDICATOR
, PPRD.UNIT
, PPRD.QUANTITY
, PPRD.ACCT_EXCHANGE_RATE) /*6012567 */
, PA_BURDEN_CMTS.GET_CMT_BURDENED_COST(NULL
, 'CMT'
, PPRD.TASK_ID
,
PPRD.EXPENDITURE_ITEM_DATE
, PPRD.EXPENDITURE_TYPE
,
PPRD.EXPENDITURE_ORGANIZATION_ID
, 'C'
, PPRD.DENOM_AMOUNT
+ JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'R'
, PPRD.REQUISITION_HEADER_ID
, PPRD.REQ_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_TRX_CURR_INDICATOR
, PPRD.UNIT
, PPRD.QUANTITY
, PPRD.ACCT_EXCHANGE_RATE) /* 6012567 */
)
, PPRD.ACCT_CURRENCY_CODE
, PPRD.ACCT_RATE_DATE
, PPRD.ACCT_RATE_TYPE
, PPRD.ACCT_EXCHANGE_RATE
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, PPRD.UNIT
, PPRD.RESOURCE_CLASS
, JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'R'
, PPRD.REQUISITION_HEADER_ID
, PPRD.REQ_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_TRX_CURR_INDICATOR
, PPRD.UNIT
, PPRD.QUANTITY
, PPRD.ACCT_EXCHANGE_RATE) /* 6012567 */
, JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'R'
, PPRD.REQUISITION_HEADER_ID
, PPRD.REQ_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR
, PPRD.UNIT
, PPRD.QUANTITY
, PPRD.ACCT_EXCHANGE_RATE) /* 6012567 */
FROM
PA_PROJ_REQ_DISTRIBUTIONS PPRD
UNION ALL
SELECT
PPPD.PROJECT_ID
,
PPPD.TASK_ID
,
'ORACLE_PURCHASING'
,
'P'
,
PPPD.PO_NUMBER
,
PPPD.PO_DISTRIBUTION_ID
,
PPPD.PO_HEADER_ID
,
PPPD.ITEM_DESCRIPTION
,
PPPD.EXPENDITURE_ITEM_DATE
,
NULL
,
NULL
,
PPPD.PO_LINE
,
PPPD.CREATION_DATE
,
PPPD.APPROVED_DATE
,
PPPD.REQUESTOR_NAME
,
PPPD.BUYER_NAME
,
PPPD.APPROVED_FLAG
,
PPPD.PROMISED_DATE
,
PPPD.NEED_BY_DATE
,
PPPD.EXPENDITURE_ORGANIZATION_ID
,
PPPD.VENDOR_ID
,
PPPD.VENDOR_NAME
,
PPPD.EXPENDITURE_TYPE
,
PPPD.EXPENDITURE_CATEGORY
,
PPPD.REVENUE_CATEGORY
,
'VI'
,
PPPD.UNIT
,
PPPD.UNIT_PRICE
,
PA_BURDEN_CMTS.GET_CMT_COMPILED_SET_ID(NULL
, 'CMT'
, PPPD.TASK_ID
, PPPD.EXPENDITURE_ITEM_DATE
, PPPD.EXPENDITURE_ORGANIZATION_ID
, PPPD.EXPENDITURE_TYPE
, 'C')
,
PPPD.ACCT_RAW_COST
+ JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'P'
, PPPD.PO_HEADER_ID
, PPPD.PO_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR
, PPPD.UNIT
, PPPD.CMT_QTY
, PPPD.ACCT_EXCHANGE_RATE)
, /*6012567 */
PA_BURDEN_CMTS.GET_CMT_BURDENED_COST(NULL
, 'CMT'
, PPPD.TASK_ID
,
PPPD.EXPENDITURE_ITEM_DATE
, PPPD.EXPENDITURE_TYPE
,
PPPD.EXPENDITURE_ORGANIZATION_ID
, 'C'
,
PPPD.ACCT_RAW_COST
+ JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'P'
, PPPD.PO_HEADER_ID
, PPPD.PO_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR
, PPPD.UNIT
, PPPD.CMT_QTY
, PPPD.ACCT_EXCHANGE_RATE) /*6012567 */
)
,
PPPD.CMT_QTY
,
PPPD.QUANTITY_ORDERED
,
PPPD.AMOUNT_ORDERED
,
PPPD.ORIGINAL_QUANTITY_ORDERED
,
PPPD.ORIGINAL_AMOUNT_ORDERED
,
PPPD.QUANTITY_CANCELLED
,
PPPD.AMOUNT_CANCELLED
,
PPPD.QUANTITY_DELIVERED
,
PPPD.QUANTITY_INVOICED
,
PPPD.AMOUNT_INVOICED
,
PPPD.QUANTITY_OUTSTANDING_DELIVERY
,
PPPD.AMOUNT_OUTSTANDING_DELIVERY
,
PPPD.QUANTITY_OUTSTANDING_INVOICE
,
PPPD.AMOUNT_OUTSTANDING_INVOICE
,
PPPD.QUANTITY_OVERBILLED
,
PPPD.AMOUNT_OVERBILLED
,
NULL
,
NULL
,
NULL
,
TO_DATE(NULL)
,
TO_NUMBER(NULL)
,
SYSDATE
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_DATE(NULL)
,
PPPD.DENOM_CURRENCY_CODE
,
PPPD.DENOM_RAW_COST
+ JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'P'
, PPPD.PO_HEADER_ID
, PPPD.PO_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_TRX_CURR_INDICATOR
, PPPD.UNIT
, PPPD.CMT_QTY
, PPPD.ACCT_EXCHANGE_RATE)
, /*6012567 */
PA_BURDEN_CMTS.GET_CMT_BURDENED_COST(NULL
, 'CMT'
, PPPD.TASK_ID
,
PPPD.EXPENDITURE_ITEM_DATE
, PPPD.EXPENDITURE_TYPE
,
PPPD.EXPENDITURE_ORGANIZATION_ID
, 'C'
,
PPPD.DENOM_RAW_COST
+ JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'P'
, PPPD.PO_HEADER_ID
, PPPD.PO_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_TRX_CURR_INDICATOR
, PPPD.UNIT
, PPPD.CMT_QTY
, PPPD.ACCT_EXCHANGE_RATE) /*6012567 */
)
,
PPPD.ACCT_CURRENCY_CODE
,
PPPD.ACCT_RATE_DATE
,
PPPD.ACCT_RATE_TYPE
,
PPPD.ACCT_EXCHANGE_RATE
,
TO_CHAR(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, PPPD.UNIT
, PPPD.RESOURCE_CLASS
, JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'P'
, PPPD.PO_HEADER_ID
, PPPD.PO_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_TRX_CURR_INDICATOR
, PPPD.UNIT
, PPPD.CMT_QTY
, PPPD.ACCT_EXCHANGE_RATE) /* 6012567 */
, JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PURCHASING'
, 'P'
, PPPD.PO_HEADER_ID
, PPPD.PO_DISTRIBUTION_ID
, JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR
, PPPD.UNIT
, PPPD.CMT_QTY
, PPPD.ACCT_EXCHANGE_RATE) /* 6012567 */
FROM
PA_PROJ_PO_DISTRIBUTIONS PPPD
WHERE PPPD.CMT_QTY <> 0
UNION ALL
SELECT
PPAID.PROJECT_ID
,
PPAID.TASK_ID
,
'ORACLE_PAYABLES'
,
'I'
,
PPAID.INVOICE_NUMBER
,
PPAID.INVOICE_DISTRIBUTION_ID
,
PPAID.INVOICE_ID
,
PPAID.DESCRIPTION
,
PPAID.EXPENDITURE_ITEM_DATE
,
NULL
,
NULL
,
PPAID.INVOICE_LINE_NUMBER
,
PPAID.INVOICE_DATE
,
TO_DATE(NULL)
,
TO_CHAR(NULL)
,
TO_CHAR(NULL)
,
PPAID.APPROVED_FLAG
,
TO_DATE(NULL)
,
TO_DATE(NULL)
,
PPAID.EXPENDITURE_ORGANIZATION_ID
,
VENDOR_ID
,
PPAID.VENDOR_NAME
,
PPAID.EXPENDITURE_TYPE
,
PPAID.EXPENDITURE_CATEGORY
,
PPAID.REVENUE_CATEGORY
,
'VI'
,
TO_CHAR(NULL)
,
TO_NUMBER(NULL)
,
PA_BURDEN_CMTS.GET_CMT_COMPILED_SET_ID(NULL
, 'CMT'
, PPAID.TASK_ID
,
PPAID.EXPENDITURE_ITEM_DATE
, PPAID.EXPENDITURE_ORGANIZATION_ID
, PPAID.EXPENDITURE_TYPE
, 'C')
,
PPAID.AMOUNT
,
PA_BURDEN_CMTS.GET_CMT_BURDENED_COST(NULL
, 'CMT'
, PPAID.TASK_ID
, PPAID.EXPENDITURE_ITEM_DATE
, PPAID.EXPENDITURE_TYPE
,
PPAID.EXPENDITURE_ORGANIZATION_ID
, 'C'
, PPAID.AMOUNT)
,
PPAID.QUANTITY
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
NULL
,
NULL
,
NULL
,
TO_DATE(NULL)
,
TO_NUMBER(NULL)
,
SYSDATE
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_DATE(NULL)
,
PPAID.DENOM_CURRENCY_CODE
,
PPAID.DENOM_AMOUNT
,
PA_BURDEN_CMTS.GET_CMT_BURDENED_COST(NULL
, 'CMT'
, PPAID.TASK_ID
, PPAID.EXPENDITURE_ITEM_DATE
, PPAID.EXPENDITURE_TYPE
,
PPAID.EXPENDITURE_ORGANIZATION_ID
, 'C'
, PPAID.DENOM_AMOUNT)
,
PPAID.ACCT_CURRENCY_CODE
,
PPAID.ACCT_RATE_DATE
,
PPAID.ACCT_RATE_TYPE
,
PPAID.ACCT_EXCHANGE_RATE
,
PPAID.RECEIPT_CURRENCY_CODE
,
PPAID.RECEIPT_CURRENCY_AMOUNT
,
PPAID.RECEIPT_EXCHANGE_RATE
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, PPAID.RESOURCE_CLASS
, TO_NUMBER(NULL) /* JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PAYABLES'
, 'I'
, PPAID.INVOICE_ID
, PPAID.DISTRIBUTION_LINE_NUMBER
, JAI_PA_COSTING_PKG.GET_TRX_CURR_INDICATOR
, NULL
, NULL ) /* 6012567 */
, TO_NUMBER(NULL) /* JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PAYABLES'
, 'I'
, PPAID.INVOICE_ID
, PPAID.DISTRIBUTION_LINE_NUMBER
, JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR
, NULL
, NULL) /* 6012567 */
FROM
PA_PROJ_AP_INV_DISTRIBUTIONS PPAID
WHERE (DENOM_AMOUNT <> 0)
UNION ALL
SELECT
PROJECT_ID
, TASK_ID
, TRANSACTION_SOURCE
, LINE_TYPE
, CMT_NUMBER
, CMT_DISTRIBUTION_ID
, CMT_HEADER_ID
, DESCRIPTION
, EXPENDITURE_ITEM_DATE
, PA_PERIOD
, GL_PERIOD
, CMT_LINE_NUMBER
, CMT_CREATION_DATE
, CMT_APPROVED_DATE
, CMT_REQUESTOR_NAME
, CMT_BUYER_NAME
, CMT_APPROVED_FLAG
, CMT_PROMISED_DATE
, CMT_NEED_BY_DATE
, ORGANIZATION_ID
, VENDOR_ID
, VENDOR_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, SYSTEM_LINKAGE_FUNCTION
, UOM_MEANING
, UNIT_PRICE
, CMT_IND_COMPILED_SET_ID
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, TOT_CMT_QUANTITY
, QUANTITY_ORDERED
, AMOUNT_ORDERED
, ORIGINAL_QUANTITY_ORDERED
, ORIGINAL_AMOUNT_ORDERED
, QUANTITY_CANCELLED
, AMOUNT_CANCELLED
, QUANTITY_DELIVERED
, QUANTITY_INVOICED
, AMOUNT_INVOICED
, QUANTITY_OUTSTANDING_DELIVERY
, AMOUNT_OUTSTANDING_DELIVERY
, QUANTITY_OUTSTANDING_INVOICE
, AMOUNT_OUTSTANDING_INVOICE
, QUANTITY_OVERBILLED
, AMOUNT_OVERBILLED
, ORIGINAL_TXN_REFERENCE1
, ORIGINAL_TXN_REFERENCE2
, ORIGINAL_TXN_REFERENCE3
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME
, WIP_RESOURCE_ID
, WIP_RESOURCE_NAME
, UNIT_OF_MEASURE
, DECODE(NVL(WIP_RESOURCE_ID
, -99)
, -99
, 'MATERIAL_ITEMS'
, 'FINANCIAL_ELEMENTS')
, TO_NUMBER(NULL) /* JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PAYABLES'
, 'I'
, PPAID.INVOICE_ID
, PPAID.DISTRIBUTION_LINE_NUMBER
, JAI_PA_COSTING_PKG.GET_TRX_CURR_INDICATOR
, NULL
, NULL ) /* 6012567 */
, TO_NUMBER(NULL) /* JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PAYABLES'
, 'I'
, PPAID.INVOICE_ID
, PPAID.DISTRIBUTION_LINE_NUMBER
, JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR
, NULL
, NULL) /* 6012567 */
FROM CST_PROJMFG_CMT_VIEW
UNION ALL
SELECT
PMPRD.PROJECT_ID
, PMPRD.TASK_ID
, 'ORACLE_PURCHASING'
, 'R'
, PMPRD.REQ_NUMBER
, PMPRD.REQ_DISTRIBUTION_ID
, PMPRD.REQUISITION_HEADER_ID
, PMPRD.ITEM_DESCRIPTION
, PMPRD.EXPENDITURE_ITEM_DATE
, NULL
, NULL
, PMPRD.REQ_LINE
, PMPRD.CREATION_DATE
, TO_DATE(NULL)
, PMPRD.REQUESTOR_NAME
, TO_CHAR(NULL)
, PMPRD.APPROVED_FLAG
, TO_DATE(NULL)
, PMPRD.NEED_BY_DATE
, PMPRD.EXPENDITURE_ORGANIZATION_ID
, PMPRD.VENDOR_ID
, PMPRD.VENDOR_NAME
, PMPRD.EXPENDITURE_TYPE
, PMPRD.EXPENDITURE_CATEGORY
, PMPRD.REVENUE_CATEGORY
, 'VI'
, PMPRD.UNIT_OF_MEASURE
, PMPRD.UNIT_PRICE
, PA_BURDEN_CMTS.GET_CMT_COMPILED_SET_ID(NULL
, 'CMT'
, PMPRD.TASK_ID
,
PMPRD.EXPENDITURE_ITEM_DATE
, PMPRD.EXPENDITURE_ORGANIZATION_ID
, PMPRD.EXPENDITURE_TYPE
, 'C')
, PMPRD.AMOUNT
, PA_BURDEN_CMTS.GET_CMT_BURDENED_COST(NULL
, 'CMT'
, PMPRD.TASK_ID
,
PMPRD.EXPENDITURE_ITEM_DATE
, PMPRD.EXPENDITURE_TYPE
,
PMPRD.EXPENDITURE_ORGANIZATION_ID
, 'C'
, PMPRD.AMOUNT)
, PMPRD.QUANTITY
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, SYSDATE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, PMPRD.DENOM_CURRENCY_CODE
, PMPRD.DENOM_AMOUNT
, PA_BURDEN_CMTS.GET_CMT_BURDENED_COST(NULL
, 'CMT'
, PMPRD.TASK_ID
,
PMPRD.EXPENDITURE_ITEM_DATE
, PMPRD.EXPENDITURE_TYPE
,
PMPRD.EXPENDITURE_ORGANIZATION_ID
, 'C'
, PMPRD.DENOM_AMOUNT)
, PMPRD.ACCT_CURRENCY_CODE
, PMPRD.ACCT_RATE_DATE
, PMPRD.ACCT_RATE_TYPE
, PMPRD.ACCT_EXCHANGE_RATE
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME
, WIP_RESOURCE_ID
, WIP_RESOURCE_NAME
, UOM_CODE
, DECODE(NVL(WIP_RESOURCE_ID
, -99)
, -99
, 'MATERIAL_ITEMS'
, 'FINANCIAL_ELEMENTS')
, TO_NUMBER(NULL) /* JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PAYABLES'
, 'I'
, PPAID.INVOICE_ID
, PPAID.DISTRIBUTION_LINE_NUMBER
, JAI_PA_COSTING_PKG.GET_TRX_CURR_INDICATOR
, NULL
, NULL ) /* 6012567 */
, TO_NUMBER(NULL) /* JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PAYABLES'
, 'I'
, PPAID.INVOICE_ID
, PPAID.DISTRIBUTION_LINE_NUMBER
, JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR
, NULL
, NULL) /* 6012567 */
FROM
PJM_REQ_COMMITMENTS_V PMPRD
UNION ALL
SELECT
PMPPD.PROJECT_ID
,
PMPPD.TASK_ID
,
'ORACLE_PURCHASING'
,
'P'
,
PMPPD.PO_NUMBER
,
PMPPD.PO_DISTRIBUTION_ID
,
PMPPD.PO_HEADER_ID
,
PMPPD.ITEM_DESCRIPTION
,
PMPPD.EXPENDITURE_ITEM_DATE
,
NULL
,
NULL
,
PMPPD.PO_LINE
,
PMPPD.CREATION_DATE
,
PMPPD.APPROVED_DATE
,
PMPPD.REQUESTOR_NAME
,
PMPPD.BUYER_NAME
,
PMPPD.APPROVED_FLAG
,
TO_DATE(NULL)
,
TO_DATE(NULL)
,
PMPPD.EXPENDITURE_ORGANIZATION_ID
,
PMPPD.VENDOR_ID
,
PMPPD.VENDOR_NAME
,
PMPPD.EXPENDITURE_TYPE
,
PMPPD.EXPENDITURE_CATEGORY
,
PMPPD.REVENUE_CATEGORY
,
'VI'
,
PMPPD.UNIT_OF_MEASURE
,
PMPPD.UNIT_PRICE
,
PA_BURDEN_CMTS.GET_CMT_COMPILED_SET_ID(NULL
, 'CMT'
, PMPPD.TASK_ID
, PMPPD.EXPENDITURE_ITEM_DATE
, PMPPD.EXPENDITURE_ORGANIZATION_ID
, PMPPD.EXPENDITURE_TYPE
, 'C')
,
PMPPD.AMOUNT_OUTSTANDING_DELIVERY
,
PA_BURDEN_CMTS.GET_CMT_BURDENED_COST(NULL
, 'CMT'
, PMPPD.TASK_ID
,
PMPPD.EXPENDITURE_ITEM_DATE
, PMPPD.EXPENDITURE_TYPE
,
PMPPD.EXPENDITURE_ORGANIZATION_ID
, 'C'
,
PMPPD.AMOUNT_OUTSTANDING_DELIVERY)
,
PMPPD.QUANTITY_OUTSTANDING_DELIVERY
,
PMPPD.QUANTITY_ORDERED
,
PMPPD.AMOUNT_ORDERED
,
PMPPD.ORIGINAL_QUANTITY_ORDERED
,
PMPPD.ORIGINAL_AMOUNT_ORDERED
,
PMPPD.QUANTITY_CANCELLED
,
PMPPD.AMOUNT_CANCELLED
,
PMPPD.QUANTITY_DELIVERED
,
PMPPD.QUANTITY_INVOICED
,
PMPPD.AMOUNT_INVOICED
,
PMPPD.QUANTITY_OUTSTANDING_DELIVERY
,
PMPPD.AMOUNT_OUTSTANDING_DELIVERY
,
PMPPD.QUANTITY_OUTSTANDING_INVOICE
,
PMPPD.AMOUNT_OUTSTANDING_INVOICE
,
PMPPD.QUANTITY_OVERBILLED
,
PMPPD.AMOUNT_OVERBILLED
,
NULL
,
NULL
,
NULL
,
TO_DATE(NULL)
,
TO_NUMBER(NULL)
,
SYSDATE
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
,
TO_DATE(NULL)
,
PMPPD.DENOM_CURRENCY_CODE
,
PMPPD.DENOM_AMT_OUTSTANDING_DELIVERY
,
PA_BURDEN_CMTS.GET_CMT_BURDENED_COST(NULL
, 'CMT'
, PMPPD.TASK_ID
,
PMPPD.EXPENDITURE_ITEM_DATE
, PMPPD.EXPENDITURE_TYPE
,
PMPPD.EXPENDITURE_ORGANIZATION_ID
, 'C'
,
PMPPD.DENOM_AMT_OUTSTANDING_DELIVERY)
,
PMPPD.ACCT_CURRENCY_CODE
,
PMPPD.ACCT_RATE_DATE
,
PMPPD.ACCT_RATE_TYPE
,
PMPPD.ACCT_EXCHANGE_RATE
,
TO_CHAR(NULL)
,
TO_NUMBER(NULL)
,
TO_NUMBER(NULL)
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME
, WIP_RESOURCE_ID
, WIP_RESOURCE_NAME
, UOM_CODE
, DECODE(NVL(WIP_RESOURCE_ID
, -99)
, -99
, 'MATERIAL_ITEMS'
, 'FINANCIAL_ELEMENTS')
, TO_NUMBER(NULL) /* JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PAYABLES'
, 'I'
, PPAID.INVOICE_ID
, PPAID.DISTRIBUTION_LINE_NUMBER
, JAI_PA_COSTING_PKG.GET_TRX_CURR_INDICATOR
, NULL
, NULL ) /* 6012567 */
, TO_NUMBER(NULL) /* JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT('ORACLE_PAYABLES'
, 'I'
, PPAID.INVOICE_ID
, PPAID.DISTRIBUTION_LINE_NUMBER
, JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR
, NULL
, NULL) /* 6012567 */
FROM
PJM_PO_COMMITMENTS_V PMPPD