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 3272: -- Need to obtain the buyers from po_headers_archive and po_releases_archive

3268: when no_data_found then
3269: null;
3270: end;
3271:
3272: -- Need to obtain the buyers from po_headers_archive and po_releases_archive
3273: -- for global buyer's need to get buyer name from per_employees_current_x
3274: if (l_document_type in ('PO', 'PA')) THEN
3275: -- there will be an entry in this table regardless of whether there is a revision
3276: -- or not

Line 3324: where person_id = (select agent_id from po_releases_archive

3320: -- or not
3321: begin
3322: select full_name into l_buyer
3323: from per_all_people_f --
3324: where person_id = (select agent_id from po_releases_archive
3325: where po_release_id = to_number(l_document_id) and
3326: revision_num = 0)
3327: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3328: exception

Line 3338: where person_id = (select agent_id from po_releases_archive

3334: begin
3335: if (l_po_revision > 0) then
3336: select full_name into l_revision_buyer
3337: from per_all_people_f --
3338: where person_id = (select agent_id from po_releases_archive
3339: where po_release_id = to_number(l_document_id) and
3340: revision_num = l_po_revision)
3341: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3342: else