[Home] [Help]
14: po_headers_all poh,
15: po_lines_all pol,
16: po_line_locations_all poll,
17: rcv_transactions rcv ,
18: gmd_sampling_events se,
19: rcv_shipment_lines rsl,
20: rcv_shipment_headers rsh
21: where segment1 = p_po_num
22: and poh.po_header_id = pol.po_header_id
89: po_headers_all poh,
90: po_lines_all pol,
91: po_line_locations_all poll,
92: rcv_transactions rcv ,
93: gmd_sampling_events se,
94: rcv_shipment_lines rsl,
95: rcv_shipment_headers rsh
96: where segment1 = p_po_num
97: and poh.po_header_id = pol.po_header_id
160: po_headers_all poh,
161: po_lines_all pol,
162: po_line_locations_all poll,
163: rcv_transactions rcv ,
164: gmd_sampling_events se,
165: rcv_shipment_lines rsl,
166: rcv_shipment_headers rsh
167: where segment1 = p_po_num
168: and poh.po_header_id = pol.po_header_id
281: po_headers_all poh,
282: po_lines_all pol,
283: po_line_locations_all poll,
284: rcv_transactions rcv ,
285: gmd_sampling_events se,
286: rcv_shipment_lines rsl,
287: rcv_shipment_headers rsh
288: where segment1 = p_po_num
289: and poh.po_header_id = pol.po_header_id
362: l_plan_id := 0;
363: END IF; -- IF (p_plan_name IS NOT NULL) THEN
364:
365: If l_id <> 0 then
366: update gmd_sampling_events
367: set
368: plan_id = l_plan_id,
369: occurrence = p_occurrence,
370: collection_id = p_collection_id,