DBA Data[Home] [Help]

APPS.WMS_RCV_PUP_PVT dependencies on WMS_PACKING_MATERIAL_GTEMP

Line 1163: FROM wms_packing_material_gtemp wpmg

1159:
1160: BEGIN
1161:
1162: SELECT Count(DISTINCT(receipt_num)) INTO l_receipt_count
1163: FROM wms_packing_material_gtemp wpmg
1164: WHERE move_order_line_id = l_tmp_mmtt_rec.move_order_line_id
1165: AND organization_id = l_tmp_mmtt_rec.organization_id;
1166:
1167: IF(l_receipt_count > 1) THEN

Line 1172: wms_packing_material_gtemp wpmg

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
1176: AND rsl.shipment_header_id = rsh.shipment_header_id