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_EMAIL_GENERATE dependencies on PO_RELEASES_ALL

Line 452: /* Bug 2791859 po_releases_all should be used instead of po_releases */

448: from po_headers_all
449: where po_header_id = l_document_id;
450:
451: elsif (l_document_type = 'RELEASE') then
452: /* Bug 2791859 po_releases_all should be used instead of po_releases */
453: select po_header_id into l_po_header_id from po_releases_all
454: where po_release_id = l_document_id;
455:
456: select authorization_status

Line 453: select po_header_id into l_po_header_id from po_releases_all

449: where po_header_id = l_document_id;
450:
451: elsif (l_document_type = 'RELEASE') then
452: /* Bug 2791859 po_releases_all should be used instead of po_releases */
453: select po_header_id into l_po_header_id from po_releases_all
454: where po_release_id = l_document_id;
455:
456: select authorization_status
457: into l_document_status

Line 2425: l_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;

2421:
2422:
2423: l_po_number PO_HEADERS_ALL.SEGMENT1%TYPE;
2424: l_po_revision NUMBER;
2425: l_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;
2426:
2427: l_date_of_order VARCHAR2(80);
2428: l_buyer VARCHAR2(80);
2429: l_date_of_revision VARCHAR2(80);

Line 2571: select po_header_id into l_po_header_id from po_releases_all

2567: /* Bug# 3046054: kagarwal
2568: ** Desc: The org_context is not yet set hence need to use the _all table
2569: */
2570:
2571: select po_header_id into l_po_header_id from po_releases_all
2572: where po_release_id = l_document_id;
2573:
2574: select authorization_status
2575: into l_document_status