[Home] [Help]
135: , rcv.organization_id
136: , rcv.subinventory
137: FROM
138: RCV_TRANSACTIONS rcv
139: ,RCV_SHIPMENT_HEADERS rsh
140: ,hr_organization_information hoi
141: WHERE rcv.shipment_header_id = rsh.shipment_header_id
142: AND rcv.organization_id = hoi.organization_id
143: AND hoi.org_information_context = 'Accounting Information'
404: , poh.type_lookup_code
405: , po.consigned_flag
406: FROM
407: RCV_TRANSACTIONS po
408: , RCV_SHIPMENT_HEADERS rsh
409: , RCV_SHIPMENT_LINES rsl
410: , PO_HEADERS_ALL poh
411: , PO_LINES_ALL pol
412: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1165: , rcv.subinventory
1166: , rcv.mvt_stat_status -- 7165989
1167: FROM
1168: RCV_TRANSACTIONS rcv
1169: , RCV_SHIPMENT_HEADERS rsh
1170: , oe_order_lines_all oola
1171: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1172: AND rcv.oe_order_line_id = oola.line_id
1173: AND rsh.receipt_num = p_movement_transaction.receipt_num
1192: , rcv.subinventory
1193: , rcv.mvt_stat_status -- 7165989
1194: FROM
1195: RCV_TRANSACTIONS rcv
1196: , RCV_SHIPMENT_HEADERS rsh
1197: , hr_organization_information hoi
1198: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1199: AND rcv.organization_id = hoi.organization_id
1200: AND hoi.org_information_context = 'Accounting Information'
1279: , oola.order_quantity_uom
1280: , ooha.sold_from_org_id -- 7165989
1281: FROM
1282: RCV_TRANSACTIONS po
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
1651: , rcv.country_of_origin_code
1652: , NVL(rsh.freight_carrier_code,'3')
1653: FROM
1654: RCV_TRANSACTIONS rcv
1655: , RCV_SHIPMENT_HEADERS rsh
1656: , RCV_SHIPMENT_LINES rsl
1657: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1658: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1659: AND rsh.shipment_header_id = rsl.shipment_header_id