DBA Data[Home] [Help]

APPS.WMS_RCV_PUP_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 1171: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh,

1167: IF(l_receipt_count > 1) THEN
1168: l_shipment_header_id := NULL;
1169: ELSE
1170: SELECT rsl.shipment_header_id INTO l_shipment_header_id
1171: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh,
1172: wms_packing_material_gtemp wpmg
1173: WHERE wpmg.move_order_line_id = l_tmp_mmtt_rec.move_order_line_id
1174: AND wpmg.organization_id = l_tmp_mmtt_rec.organization_id
1175: AND rsh.receipt_num = wpmg.receipt_num