VIEW: APPS.CSTFV_RCV_ACQ_COSTS

Source

View Text - Preformatted

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 ,pla.line_num ,pha.segment1 ,plla.shipment_num ,decode(plla.MATCH_OPTION, 'P', 'PO', 'R', 'Receipt', NULL) ,mp.organization_code ,haou.name /* ID */ ,crac.PO_LINE_LOCATION_ID /* WHO */ ,crac.creation_date ,crac.created_by ,crac.last_update_date ,crac.last_updated_by from PO_HEADERS_ALL pha, PO_LINES_ALL pla, PO_LINE_LOCATIONS_ALL plla, hr_all_organization_units haou, mtl_parameters mp, 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 plla.line_location_id (+) = crac.po_line_location_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 and pla.po_line_id (+) = plla.po_line_id and pha.po_header_id (+) = pla.po_header_id with read only

View Text - HTML Formatted

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
, PLA.LINE_NUM
, PHA.SEGMENT1
, PLLA.SHIPMENT_NUM
, DECODE(PLLA.MATCH_OPTION
, 'P'
, 'PO'
, 'R'
, 'RECEIPT'
, NULL)
, MP.ORGANIZATION_CODE
, HAOU.NAME /* ID */
, CRAC.PO_LINE_LOCATION_ID /* WHO */
, CRAC.CREATION_DATE
, CRAC.CREATED_BY
, CRAC.LAST_UPDATE_DATE
, CRAC.LAST_UPDATED_BY
FROM PO_HEADERS_ALL PHA
, PO_LINES_ALL PLA
, PO_LINE_LOCATIONS_ALL PLLA
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, 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 PLLA.LINE_LOCATION_ID (+) = CRAC.PO_LINE_LOCATION_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
AND PLA.PO_LINE_ID (+) = PLLA.PO_LINE_ID
AND PHA.PO_HEADER_ID (+) = PLA.PO_HEADER_ID WITH READ ONLY