DBA Data[Home] [Help]

APPS.GMD_QA_RCV_PUB dependencies on PO_LINES_ALL

Line 18: --po_lines_all pol,

14: /*CURSOR cur_get_disposition IS -- 7447810 optimized query for shipment_line_id
15: select disposition
16: from
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,

Line 45: po_lines_all pol,

41: CURSOR cur_get_disposition IS -- 7447810 optimized query for shipment_line_id
42: select disposition
43: from
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,

Line 136: --po_lines_all pol,

132: /*CURSOR cur_get_quantity IS -- 7447810 optimized query for shipment_line_id
133: select rcv.quantity
134: from
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,

Line 162: po_lines_all pol,

158: CURSOR cur_get_quantity IS -- 7447810 optimized query for shipment_line_id
159: select rcv.quantity
160: from
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,

Line 251: --po_lines_all pol,

247: /*CURSOR cur_get_inspection_result IS -- 7447810 optimized query for shipment_line_id
248: select disposition
249: from
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,

Line 278: po_lines_all pol,

274: CURSOR cur_get_inspection_result IS -- 7447810 optimized query for shipment_line_id
275: select disposition
276: from
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,

Line 420: po_lines_all pol,

416: CURSOR cur_get_id IS
417: select sampling_event_id
418: from
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,