[Home] [Help]
141: , rcv.shipment_header_id
142: , rcv.shipment_line_id
143: FROM
144: RCV_TRANSACTIONS rcv
145: ,RCV_SHIPMENT_HEADERS rsh
146: ,hr_organization_information hoi
147: WHERE rcv.shipment_header_id = rsh.shipment_header_id
148: AND rcv.organization_id = hoi.organization_id
149: AND hoi.org_information_context = 'Accounting Information'
410: , poh.type_lookup_code
411: , po.consigned_flag
412: FROM
413: RCV_TRANSACTIONS po
414: , RCV_SHIPMENT_HEADERS rsh
415: , RCV_SHIPMENT_LINES rsl
416: , PO_HEADERS_ALL poh
417: , PO_LINES_ALL pol
418: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1249: , rcv.subinventory
1250: , rcv.mvt_stat_status -- 7165989
1251: FROM
1252: RCV_TRANSACTIONS rcv
1253: , RCV_SHIPMENT_HEADERS rsh
1254: , oe_order_lines_all oola
1255: , hr_organization_information hoi /*Bug 8467743*/
1256: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1257: AND rcv.oe_order_line_id = oola.line_id
1281: , rcv.subinventory
1282: , rcv.mvt_stat_status -- 7165989
1283: FROM
1284: RCV_TRANSACTIONS rcv
1285: , RCV_SHIPMENT_HEADERS rsh
1286: , hr_organization_information hoi
1287: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1288: AND rcv.organization_id = hoi.organization_id
1289: AND hoi.org_information_context = 'Accounting Information'
1383: , ooha.sold_from_org_id -- 7165989
1384: , oola.return_attribute2 -- 8435314
1385: FROM
1386: RCV_TRANSACTIONS po
1387: , RCV_SHIPMENT_HEADERS rsh
1388: , RCV_SHIPMENT_LINES rsl
1389: , OE_ORDER_HEADERS_ALL ooha
1390: , OE_ORDER_LINES_ALL oola
1391: --, MTL_SYSTEM_ITEMS si
1810: , rcv.country_of_origin_code
1811: , NVL(rsh.freight_carrier_code,'3')
1812: FROM
1813: RCV_TRANSACTIONS rcv
1814: , RCV_SHIPMENT_HEADERS rsh
1815: , RCV_SHIPMENT_LINES rsl
1816: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1817: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1818: AND rsh.shipment_header_id = rsl.shipment_header_id