eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QA_RCV_PUB dependencies on PO_HEADERS_ALL

Line 17: --po_headers_all poh,

13: -- Bug 13980338 - ENHANCED QUALITY RECEIVING GIVES INCORRECT RESULTS. comment out old cursor aand see new cursor
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,

Line 44: po_headers_all poh,

40:
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,

Line 135: --po_headers_all poh,

131: -- Bug 13980338 - ENHANCED QUALITY RECEIVING GIVES INCORRECT RESULTS. comment out old cursor aand see new cursor
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,

Line 161: po_headers_all poh,

157: order by rcv.creation_date desc; */
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,

Line 250: --po_headers_all poh,

246: -- Bug 13980338 - ENHANCED QUALITY RECEIVING GIVES INCORRECT RESULTS. comment out old cursor aand see new cursor
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,

Line 277: po_headers_all poh,

273:
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,

Line 419: po_headers_all poh,

415:
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,