Product: | BOM - Bills of Material |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CSTBV_RCV_ACQ_COSTS |
SELECT CRAC.HEADER_ID /*PK*/
, CRAC.COST_GROUP_ID
, CRAC.COST_TYPE_ID
, CRAC.PERIOD_ID
, CRAC.RCV_TRANSACTION_ID
, CRAC.NET_QUANTITY_RECEIVED
, CRAC.TOTAL_QUANTITY_INVOICED
, CRAC.QUANTITY_AT_PO_PRICE
, CRAC.TOTAL_INVOICE_AMOUNT
, CRAC.AMOUNT_AT_PO_PRICE
, CRAC.TOTAL_AMOUNT
, CRAC.COSTED_QUANTITY
, CRAC.ACQUISITION_COST
, CRAC.PO_UNIT_PRICE
, CRAC.PRIMARY_UOM
, CRAC.REC_EXCHG_RATE /* FOREIGN KEYS RESOLVED */
, CCG.COST_GROUP
, CCT.COST_TYPE
, CPP.PERIOD_NAME
, RT.TRANSACTION_TYPE
, RT.TRANSACTION_DATE /* ID */
, CRAC.PO_LINE_LOCATION_ID /* WHO */
, CRAC.CREATION_DATE
, CRAC.CREATED_BY
, CRAC.LAST_UPDATE_DATE
, CRAC.LAST_UPDATED_BY
FROM CST_PAC_PERIODS CPP
, CST_COST_GROUPS CCG
, CST_COST_TYPES CCT
, RCV_TRANSACTIONS RT
, CST_RCV_ACQ_COSTS CRAC
WHERE 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