746: OE_ORDER_HEADERS_ALL ooha
747: , OE_ORDER_LINES_ALL oola
748: , HZ_PARTIES rac
749: , HZ_CUST_ACCOUNTS hzc
750: , MTL_SYSTEM_ITEMS si
751: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
752: WHERE ooha.header_id = oola.header_id
753: AND oola.inventory_item_id = si.inventory_item_id
754: AND oola.ship_from_org_id = si.organization_id
1283: , RCV_SHIPMENT_HEADERS rsh
1284: , RCV_SHIPMENT_LINES rsl
1285: , OE_ORDER_HEADERS_ALL ooha
1286: , OE_ORDER_LINES_ALL oola
1287: --, MTL_SYSTEM_ITEMS si
1288: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1289: WHERE po.shipment_header_id = rsh.shipment_header_id
1290: AND rsh.shipment_header_id = rsl.shipment_header_Id
1291: AND po.shipment_line_id = rsl.shipment_line_id