[Home] [Help]
18: --po_lines_all pol,
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
45: po_lines_all pol,
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
136: --po_lines_all pol,
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
162: po_lines_all pol,
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
251: --po_lines_all pol,
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
278: po_lines_all pol,
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
420: po_lines_all pol,
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