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 498: /* Bug 2791859 po_releases_all should be used instead of po_releases */

494: from po_headers_all
495: where po_header_id = l_document_id;
496:
497: elsif (l_document_type = 'RELEASE') then
498: /* Bug 2791859 po_releases_all should be used instead of po_releases */
499: select po_header_id into l_po_header_id from po_releases_all
500: where po_release_id = l_document_id;
501:
502: select authorization_status

Line 499: select po_header_id into l_po_header_id from po_releases_all

495: where po_header_id = l_document_id;
496:
497: elsif (l_document_type = 'RELEASE') then
498: /* Bug 2791859 po_releases_all should be used instead of po_releases */
499: select po_header_id into l_po_header_id from po_releases_all
500: where po_release_id = l_document_id;
501:
502: select authorization_status
503: into l_document_status

Line 2646: l_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;

2642:
2643:
2644: l_po_number PO_HEADERS_ALL.SEGMENT1%TYPE;
2645: l_po_revision NUMBER;
2646: l_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;
2647:
2648: l_date_of_order VARCHAR2(80);
2649: l_buyer per_all_people_f.full_name%TYPE; --bug 15957689
2650: l_date_of_revision VARCHAR2(80);

Line 2833: select po_header_id into l_po_header_id from po_releases_all

2829: /* Bug# 3046054: kagarwal
2830: ** Desc: The org_context is not yet set hence need to use the _all table
2831: */
2832:
2833: select po_header_id into l_po_header_id from po_releases_all
2834: where po_release_id = l_document_id;
2835:
2836: select authorization_status
2837: into l_document_status