View: CSTFV_RCV_ACQ_COST_DETAILS

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CSTFV_RCV_ACQ_COST_DETAILS

View Text

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
, PLA.LINE_NUM
, PHA.SEGMENT1
, PLLA.SHIPMENT_NUM
, DECODE(PLLA.MATCH_OPTION
, 'P'
, 'PO'
, 'R'
, 'RECEIPT'
, NULL)
, MP.ORGANIZATION_CODE
, HAOU.NAME /* 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
, AIDA.INVOICE_ID
, AIDA1.INVOICE_ID
, AIDA2.INVOICE_ID
, PLA.PO_HEADER_ID /* WHO */
, CRACD.CREATION_DATE
, CRACD.CREATED_BY
, CRACD.LAST_UPDATE_DATE
, CRACD.LAST_UPDATED_BY
FROM PO_LINES_ALL PLA
, PO_LINE_LOCATIONS_ALL PLLA
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, PO_HEADERS_ALL PHA
, CST_PAC_PERIODS CPP
, CST_COST_GROUPS CCG
, CST_COST_TYPES CCT
, RCV_TRANSACTIONS RT
, AP_INVOICES_ALL AIA2
, AP_INVOICES_ALL AIA1
, AP_INVOICES_ALL AIA
, 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.PARENT_INVOICE_DIST_ID = AIDA2.INVOICE_DISTRIBUTION_ID (+)
AND CRACD.INVOICE_DISTRIBUTION_ID = AIDA1.INVOICE_DISTRIBUTION_ID (+)
AND CRACD.PARENT_DISTRIBUTION_ID = AIDA.INVOICE_DISTRIBUTION_ID (+)
AND AIDA.INVOICE_ID = AIA.INVOICE_ID (+)
AND AIDA2.INVOICE_ID = AIA2.INVOICE_ID (+)
AND AIDA1.INVOICE_ID = AIA1.INVOICE_ID (+)
AND PLA.PO_LINE_ID (+) = PLLA.PO_LINE_ID
AND PLLA.LINE_LOCATION_ID (+) = CRACD.PO_LINE_LOCATION_ID AND PHA.PO_HEADER_ID (+) = PLA.PO_HEADER_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
AND PLLA.SHIP_TO_ORGANIZATION_ID = MP.ORGANIZATION_ID (+)
AND HAOU.ORGANIZATION_ID (+) = PLLA.SHIP_TO_ORGANIZATION_ID WITH READ ONLY

Columns