19: --po_line_locations_all poll,
20: rcv_transactions rcv ,
21: gmd_sampling_events se,
22: rcv_shipment_lines rsl,
23: rcv_shipment_headers rsh
24: where
25: -- segment1 = p_po_num
26: --and poh.po_header_id = pol.po_header_id
27: --and rsl.line_num = p_po_line_num
46: po_line_locations_all poll,
47: rcv_transactions rcv ,
48: gmd_sampling_events se,
49: rcv_shipment_lines rsl,
50: rcv_shipment_headers rsh
51: where
52: segment1 = p_po_num
53: and poh.po_header_id = pol.po_header_id
54: --and rsl.line_num = p_shipment_num --p_po_line_num - CHANGED FOR 14249028 take this out
137: --po_line_locations_all poll,
138: rcv_transactions rcv ,
139: gmd_sampling_events se,
140: rcv_shipment_lines rsl,
141: rcv_shipment_headers rsh
142: where
143: -- segment1 = p_po_num
144: --and poh.po_header_id = pol.po_header_id
145: --and rsl.line_num = p_po_line_num
163: po_line_locations_all poll,
164: rcv_transactions rcv ,
165: gmd_sampling_events se,
166: rcv_shipment_lines rsl,
167: rcv_shipment_headers rsh
168: where
169: segment1 = p_po_num
170: and poh.po_header_id = pol.po_header_id
171: --and rsl.line_num = p_shipment_num --p_po_line_num - CHANGED FOR 14249028
252: --po_line_locations_all poll,
253: rcv_transactions rcv ,
254: gmd_sampling_events se,
255: rcv_shipment_lines rsl,
256: rcv_shipment_headers rsh
257: where
258: -- segment1 = p_po_num
259: --and poh.po_header_id = pol.po_header_id
260: --and rsl.line_num = p_po_line_num
279: po_line_locations_all poll,
280: rcv_transactions rcv ,
281: gmd_sampling_events se,
282: rcv_shipment_lines rsl,
283: rcv_shipment_headers rsh
284: where
285: segment1 = p_po_num
286: and poh.po_header_id = pol.po_header_id
287: --and rsl.line_num = p_shipment_num --p_po_line_num - CHANGED FOR 14249028
421: po_line_locations_all poll,
422: rcv_transactions rcv ,
423: gmd_sampling_events se,
424: rcv_shipment_lines rsl,
425: rcv_shipment_headers rsh
426: where segment1 = p_po_num
427: and poh.po_header_id = pol.po_header_id
428: --and rsl.line_num = p_shipment_num --p_po_line_num - CHANGED FOR 14249028
429: and pol.line_num = p_po_line_num