[Home] [Help]
17: --po_headers_all poh,
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
44: po_headers_all poh,
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
135: --po_headers_all poh,
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
161: po_headers_all poh,
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
250: --po_headers_all poh,
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
277: po_headers_all poh,
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
419: po_headers_all poh,
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
496: l_plan_id := 0;
497: END IF; -- IF (p_plan_name IS NOT NULL) THEN
498:
499: If l_id <> 0 then
500: update gmd_sampling_events
501: set
502: plan_id = l_plan_id,
503: occurrence = p_occurrence,
504: collection_id = p_collection_id,