eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CSTFV_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 ,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

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
, 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