DBA Data[Home] [Help]

APPS.POR_RCV_TRANSACTION_SV dependencies on RCV_SHIPMENT_HEADERS

Line 868: rcv_shipment_headers rh,

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
872: and rt.shipment_line_id = rl.shipment_line_id

Line 924: rcv_shipment_headers rsh,

920: CURSOR c_req_shipment (c_req_line_id NUMBER) IS
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;

Line 934: rcv_shipment_headers rsh,

930: CURSOR c_po_shipment (c_line_location_id NUMBER) IS
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