[Home] [Help]
71: X_ITEM_ID,
72: X_PARENT_TYPE,
73: X_TXN_ORG_ID
74: FROM RCV_TRANSACTIONS RT,
75: RCV_SHIPMENT_LINES RL,
76: PO_HEADERS_ALL PH,
77: OE_ORDER_HEADERS_ALL OH
78: WHERE RT.TRANSACTION_ID = P_PARENT_TRANSACTION_ID
79: AND RT.SHIPMENT_LINE_ID = RL.SHIPMENT_LINE_ID
863: pol.matching_basis,
864: x_parent_interface_txn_id,
865: nvl(x_uom_code,rt.uom_code)
866: from rcv_transactions rt,
867: rcv_shipment_lines rl,
868: rcv_shipment_headers rh,
869: mtl_system_items msi,
870: po_Lines_all pol
871: where transaction_id = p_parent_transaction_id
921: SELECT
922: rsh.shipment_num, rsh.shipment_header_id
923: FROM
924: rcv_shipment_headers rsh,
925: rcv_shipment_lines rsl
926: WHERE
927: rsh.shipment_header_id = rsl.shipment_header_id and
928: rsl.requisition_line_id = c_req_line_id;
929:
931: SELECT
932: rsh.shipment_num, rsh.shipment_header_id
933: FROM
934: rcv_shipment_headers rsh,
935: rcv_shipment_lines rsl
936: WHERE
937: rsh.shipment_header_id = rsl.shipment_header_id and
938: rsl.po_line_location_id = c_line_location_id and
939: rsh.asn_type is not null;