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_ARCHIVE

Line 3730: -- Need to obtain the buyers from po_headers_archive and po_releases_archive

3726: when no_data_found then
3727: null;
3728: end;
3729:
3730: -- Need to obtain the buyers from po_headers_archive and po_releases_archive
3731: -- for global buyer's need to get buyer name from per_employees_current_x
3732: if (l_document_type in ('PO', 'PA')) THEN
3733: -- there will be an entry in this table regardless of whether there is a revision
3734: -- or not

Line 3782: where person_id = (select agent_id from po_releases_archive

3778: -- or not
3779: begin
3780: select full_name into l_buyer
3781: from per_all_people_f --
3782: where person_id = (select agent_id from po_releases_archive
3783: where po_release_id = to_number(l_document_id) and
3784: revision_num = 0)
3785: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3786: exception

Line 3796: where person_id = (select agent_id from po_releases_archive

3792: begin
3793: if (l_po_revision > 0) then
3794: select full_name into l_revision_buyer
3795: from per_all_people_f --
3796: where person_id = (select agent_id from po_releases_archive
3797: where po_release_id = to_number(l_document_id) and
3798: revision_num = l_po_revision)
3799: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3800: else