VIEW: APPS.CSTBV_RCV_ACQ_COST_DETAILS

Source

View Text - Preformatted

SELECT cracd.HEADER_ID /*PK*/ ,cracd.DETAIL_ID /*PK*/ ,cracd.SOURCE_TYPE ,cracd.LEVEL_NUM ,cracd.AMOUNT ,cracd.QUANTITY ,cracd.PRICE ,cracd.LINE_TYPE ,cracd.DISTRIBUTION_NUM /* FOREIGN KEYS RESOLVED */ ,ccg.cost_group ,cct.cost_type ,cpp.period_name ,rt.TRANSACTION_TYPE ,rt.TRANSACTION_DATE ,aia2.INVOICE_NUM ,aia1.INVOICE_NUM ,aia.INVOICE_NUM ,aida2.DISTRIBUTION_LINE_NUMBER ,aida1.DISTRIBUTION_LINE_NUMBER ,aida.DISTRIBUTION_LINE_NUMBER /* ID */ ,cracd.PO_LINE_LOCATION_ID ,cracd.PARENT_DISTRIBUTION_ID ,cracd.INVOICE_DISTRIBUTION_ID ,cracd.PARENT_INVOICE_DIST_ID ,crac.COST_GROUP_ID ,crac.COST_TYPE_ID ,crac.PERIOD_ID ,crac.RCV_TRANSACTION_ID /* WHO */ ,cracd.creation_date ,cracd.created_by ,cracd.last_update_date ,cracd.last_updated_by from CST_PAC_PERIODS cpp, CST_COST_GROUPS ccg, CST_COST_TYPES cct, RCV_TRANSACTIONS rt, ap_invoices_all aia, ap_invoices_all aia1, ap_invoices_all aia2, ap_invoice_distributions_all aida, ap_invoice_distributions_all aida1, ap_invoice_distributions_all aida2, CST_RCV_ACQ_COSTS crac, CST_RCV_ACQ_COST_DETAILS cracd WHERE cracd.PARENT_DISTRIBUTION_ID = aida.INVOICE_DISTRIBUTION_ID (+) and cracd.INVOICE_DISTRIBUTION_ID = aida1.INVOICE_DISTRIBUTION_ID (+) and cracd.PARENT_INVOICE_DIST_ID = aida2.INVOICE_DISTRIBUTION_ID (+) and aida.INVOICE_ID = aia.INVOICE_ID (+) and aida1.INVOICE_ID = aia1.INVOICE_ID (+) and aida2.INVOICE_ID = aia2.INVOICE_ID (+) and crac.header_id = cracd.header_id and crac.PERIOD_ID = cpp.PAC_PERIOD_ID and crac.cost_group_id = ccg.cost_group_id and crac.cost_type_id = cct.cost_type_id and crac.RCV_TRANSACTION_ID = rt.TRANSACTION_ID with read only

View Text - HTML Formatted

SELECT CRACD.HEADER_ID /*PK*/
, CRACD.DETAIL_ID /*PK*/
, CRACD.SOURCE_TYPE
, CRACD.LEVEL_NUM
, CRACD.AMOUNT
, CRACD.QUANTITY
, CRACD.PRICE
, CRACD.LINE_TYPE
, CRACD.DISTRIBUTION_NUM /* FOREIGN KEYS RESOLVED */
, CCG.COST_GROUP
, CCT.COST_TYPE
, CPP.PERIOD_NAME
, RT.TRANSACTION_TYPE
, RT.TRANSACTION_DATE
, AIA2.INVOICE_NUM
, AIA1.INVOICE_NUM
, AIA.INVOICE_NUM
, AIDA2.DISTRIBUTION_LINE_NUMBER
, AIDA1.DISTRIBUTION_LINE_NUMBER
, AIDA.DISTRIBUTION_LINE_NUMBER /* ID */
, CRACD.PO_LINE_LOCATION_ID
, CRACD.PARENT_DISTRIBUTION_ID
, CRACD.INVOICE_DISTRIBUTION_ID
, CRACD.PARENT_INVOICE_DIST_ID
, CRAC.COST_GROUP_ID
, CRAC.COST_TYPE_ID
, CRAC.PERIOD_ID
, CRAC.RCV_TRANSACTION_ID /* WHO */
, CRACD.CREATION_DATE
, CRACD.CREATED_BY
, CRACD.LAST_UPDATE_DATE
, CRACD.LAST_UPDATED_BY
FROM CST_PAC_PERIODS CPP
, CST_COST_GROUPS CCG
, CST_COST_TYPES CCT
, RCV_TRANSACTIONS RT
, AP_INVOICES_ALL AIA
, AP_INVOICES_ALL AIA1
, AP_INVOICES_ALL AIA2
, AP_INVOICE_DISTRIBUTIONS_ALL AIDA
, AP_INVOICE_DISTRIBUTIONS_ALL AIDA1
, AP_INVOICE_DISTRIBUTIONS_ALL AIDA2
, CST_RCV_ACQ_COSTS CRAC
, CST_RCV_ACQ_COST_DETAILS CRACD
WHERE CRACD.PARENT_DISTRIBUTION_ID = AIDA.INVOICE_DISTRIBUTION_ID (+)
AND CRACD.INVOICE_DISTRIBUTION_ID = AIDA1.INVOICE_DISTRIBUTION_ID (+)
AND CRACD.PARENT_INVOICE_DIST_ID = AIDA2.INVOICE_DISTRIBUTION_ID (+)
AND AIDA.INVOICE_ID = AIA.INVOICE_ID (+)
AND AIDA1.INVOICE_ID = AIA1.INVOICE_ID (+)
AND AIDA2.INVOICE_ID = AIA2.INVOICE_ID (+)
AND CRAC.HEADER_ID = CRACD.HEADER_ID
AND CRAC.PERIOD_ID = CPP.PAC_PERIOD_ID
AND CRAC.COST_GROUP_ID = CCG.COST_GROUP_ID
AND CRAC.COST_TYPE_ID = CCT.COST_TYPE_ID
AND CRAC.RCV_TRANSACTION_ID = RT.TRANSACTION_ID WITH READ ONLY