CST_TXN_INVOICE_ASC

Details

Schema: FUSION
Object owner: CST
Object type: VIEW

Columns

Name
TRANSACTION_ID TRANSACTION_COST_ID CMR_AP_INVOICE_DIST_ID

Name

TRANSACTION_ID

TRANSACTION_COST_ID

CMR_AP_INVOICE_DIST_ID

Query

SQL_Statement
SELECT CT.TRANSACTION_ID, CTC.TRANSACTION_COST_ID, MAX(DECODE(CACA.CMR_AP_INVOICE_DIST_ID, -1, CITC.CMR_AP_INVOICE_DIST_ID, CACA.CMR_AP_INVOICE_DIST_ID)) CMR_AP_INVOICE_DIST_ID FROM CST_TRANSACTION_COSTS CTC, CST_TRANSACTIONS CT, CST_INCOMING_TXN_COST_SOURCES CITC, CST_ACQ_COST_ADJ_SOURCES CACA WHERE CT.TRANSACTION_ID = CTC.TRANSACTION_ID AND CTC.ADJUSTMENT_TRANSACTION_ID = CACA.ADJUSTMENT_TRANSACTION_ID (+) AND CT.CST_INV_TRANSACTION_ID = CITC.CST_INV_TRANSACTION_ID (+) GROUP BY CT.TRANSACTION_ID, CTC.TRANSACTION_COST_ID

SQL_Statement

SELECT CT.TRANSACTION_ID, CTC.TRANSACTION_COST_ID, MAX(DECODE(CACA.CMR_AP_INVOICE_DIST_ID, -1, CITC.CMR_AP_INVOICE_DIST_ID, CACA.CMR_AP_INVOICE_DIST_ID)) CMR_AP_INVOICE_DIST_ID

FROM CST_TRANSACTION_COSTS CTC, CST_TRANSACTIONS CT, CST_INCOMING_TXN_COST_SOURCES CITC, CST_ACQ_COST_ADJ_SOURCES CACA

WHERE CT.TRANSACTION_ID = CTC.TRANSACTION_ID

AND CTC.ADJUSTMENT_TRANSACTION_ID = CACA.ADJUSTMENT_TRANSACTION_ID (+)

AND CT.CST_INV_TRANSACTION_ID = CITC.CST_INV_TRANSACTION_ID (+)

GROUP BY CT.TRANSACTION_ID, CTC.TRANSACTION_COST_ID