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.PO_CHG_REQUEST_PVT dependencies on PO_ACCEPTANCES

Line 255: FROM po_acceptances

251: */
252: if p_po_release_id is null then
253: SELECT ACCEPTED_FLAG
254: INTO l_accepted_flag
255: FROM po_acceptances
256: WHERE po_header_id = p_po_header_id
257: AND REVISION_NUM = p_revision_num
258: AND PO_LINE_LOCATION_ID IS NULL
259: AND ACCEPTING_PARTY='S';

Line 263: FROM po_acceptances

259: AND ACCEPTING_PARTY='S';
260: ELSE
261: SELECT ACCEPTED_FLAG
262: INTO l_accepted_flag
263: FROM po_acceptances
264: WHERE po_release_id = p_po_release_id
265: AND REVISION_NUM = p_revision_num
266: AND PO_LINE_LOCATION_ID IS NULL
267: AND ACCEPTING_PARTY='S';

Line 2370: from po_acceptances

2366:
2367: if ( x_ack_stat in ('REJECTED','ACCEPTED')) then
2368: begin
2369: select note into x_note
2370: from po_acceptances
2371: where po_line_location_id=p_line_location_id and
2372: revision_num = x_revision;
2373: exception
2374: when others then

Line 2434: from po_acceptances

2430:
2431: if ( x_ack_stat = 'REJECTED') then
2432: begin
2433: select note into x_note
2434: from po_acceptances
2435: where po_line_location_id=p_line_location_id and
2436: revision_num = x_revision;
2437: exception
2438: when others then