VIEW: APPS.CST_LC_ADJ_INTERFACE_V

Source

View Text - Preformatted

SELECT clai.rowid, clai.transaction_id , clai.rcv_transaction_id , clai.organization_id , clai.inventory_item_id , clai.transaction_date , clai.prior_landed_cost , clai.new_landed_cost , clai.process_status , clai.process_phase , clai.group_id , clai.creation_date , clai.created_by , clai.last_update_date , clai.last_updated_by , clai.last_update_login , clai.request_id , clai.program_application_id , clai.program_id , clai.program_update_date , ml5.meaning process_phase_meaning, ml6.meaning process_status_meaning, mp.organization_code organization_code, cod.organization_name organization_name , rt.po_header_id , poh.segment1 po_number , rt.po_line_id po_line_id , pol.line_num po_line_num , rsh.receipt_num receipt_num , rt.po_line_location_id line_location_id , msi.description item_description , rsl.line_num receipt_line_num, rsh.shipment_header_id , rsl.shipment_line_id FROM cst_lc_adj_interface clai, rcv_transactions rt, po_headers_all poh, po_lines_all pol, rcv_shipment_headers rsh, rcv_shipment_lines rsl, mtl_system_items_vl msi, cst_organization_definitions cod, mtl_parameters mp, mfg_lookups ml5, mfg_lookups ml6 WHERE clai.rcv_transaction_id = rt.transaction_id and clai.inventory_item_id = msi.inventory_item_id and clai.organization_id = mp.organization_id and mp.organization_id = cod.organization_id and msi.organization_id = mp.organization_id and rt.shipment_header_id = rsh.shipment_header_id and rsh.shipment_header_id = rsl.shipment_header_id and rsl.shipment_line_id = rt.shipment_line_id and rsl.shipment_header_id = rt.shipment_header_id and poh.po_header_id = rt.po_header_id and pol.po_line_id = rt.po_line_id and ml5.lookup_type = 'LANDED_COST_ADJ_PROCESS_PHASE' and ml5.lookup_code = clai.process_phase and ml6.lookup_type = 'LANDED_COST_ADJ_PROCESS_STATUS' and ml6.lookup_code = clai.process_status

View Text - HTML Formatted

SELECT CLAI.ROWID
, CLAI.TRANSACTION_ID
, CLAI.RCV_TRANSACTION_ID
, CLAI.ORGANIZATION_ID
, CLAI.INVENTORY_ITEM_ID
, CLAI.TRANSACTION_DATE
, CLAI.PRIOR_LANDED_COST
, CLAI.NEW_LANDED_COST
, CLAI.PROCESS_STATUS
, CLAI.PROCESS_PHASE
, CLAI.GROUP_ID
, CLAI.CREATION_DATE
, CLAI.CREATED_BY
, CLAI.LAST_UPDATE_DATE
, CLAI.LAST_UPDATED_BY
, CLAI.LAST_UPDATE_LOGIN
, CLAI.REQUEST_ID
, CLAI.PROGRAM_APPLICATION_ID
, CLAI.PROGRAM_ID
, CLAI.PROGRAM_UPDATE_DATE
, ML5.MEANING PROCESS_PHASE_MEANING
, ML6.MEANING PROCESS_STATUS_MEANING
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, COD.ORGANIZATION_NAME ORGANIZATION_NAME
, RT.PO_HEADER_ID
, POH.SEGMENT1 PO_NUMBER
, RT.PO_LINE_ID PO_LINE_ID
, POL.LINE_NUM PO_LINE_NUM
, RSH.RECEIPT_NUM RECEIPT_NUM
, RT.PO_LINE_LOCATION_ID LINE_LOCATION_ID
, MSI.DESCRIPTION ITEM_DESCRIPTION
, RSL.LINE_NUM RECEIPT_LINE_NUM
, RSH.SHIPMENT_HEADER_ID
, RSL.SHIPMENT_LINE_ID
FROM CST_LC_ADJ_INTERFACE CLAI
, RCV_TRANSACTIONS RT
, PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, MTL_SYSTEM_ITEMS_VL MSI
, CST_ORGANIZATION_DEFINITIONS COD
, MTL_PARAMETERS MP
, MFG_LOOKUPS ML5
, MFG_LOOKUPS ML6
WHERE CLAI.RCV_TRANSACTION_ID = RT.TRANSACTION_ID
AND CLAI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND CLAI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = COD.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND RSL.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID
AND POH.PO_HEADER_ID = RT.PO_HEADER_ID
AND POL.PO_LINE_ID = RT.PO_LINE_ID
AND ML5.LOOKUP_TYPE = 'LANDED_COST_ADJ_PROCESS_PHASE'
AND ML5.LOOKUP_CODE = CLAI.PROCESS_PHASE
AND ML6.LOOKUP_TYPE = 'LANDED_COST_ADJ_PROCESS_STATUS'
AND ML6.LOOKUP_CODE = CLAI.PROCESS_STATUS