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 PER_ALL_PEOPLE_F

Line 133: l_phone per_all_people_f.work_telephone%TYPE;

129: l_requestor_name po_distributions_print.requestor_name%TYPE;
130: l_requestor_id po_distributions_print.requestor_id%TYPE;
131:
132: /* Bug 2870932 increased the size */
133: l_phone per_all_people_f.work_telephone%TYPE;
134: l_email_address per_all_people_f.email_address%TYPE;
135: /* End of Bug 2870932 */
136:
137: l_requestor_count NUMBER := 0;

Line 134: l_email_address per_all_people_f.email_address%TYPE;

130: l_requestor_id po_distributions_print.requestor_id%TYPE;
131:
132: /* Bug 2870932 increased the size */
133: l_phone per_all_people_f.work_telephone%TYPE;
134: l_email_address per_all_people_f.email_address%TYPE;
135: /* End of Bug 2870932 */
136:
137: l_requestor_count NUMBER := 0;
138: l_multiple_flag varchar2(1);

Line 1517: from per_all_people_f

1513: begin
1514:
1515: select full_name,work_telephone,email_address
1516: into l_requestor_name,l_phone,l_email_address
1517: from per_all_people_f
1518: where person_id = l_requestor_id
1519: and effective_start_date <= sysdate
1520: and effective_end_date >= sysdate;
1521:

Line 1671: from per_all_people_f

1667: if (l_requestor_id <> 0) then
1668: begin
1669: select full_name,work_telephone,email_address
1670: into l_requestor_name,l_phone,l_email_address
1671: from per_all_people_f
1672: where person_id = l_requestor_id
1673: and effective_start_date <= sysdate
1674: and effective_end_date >= sysdate;
1675: exception

Line 2467: from per_all_people_f

2463: if (l_requestor_id <> 0) then
2464: begin
2465: select full_name,work_telephone,email_address
2466: into l_requestor_name,l_phone,l_email_address
2467: from per_all_people_f
2468: where person_id = l_requestor_id
2469: and effective_start_date <= sysdate
2470: and effective_end_date >= sysdate;
2471: exception

Line 2649: l_buyer per_all_people_f.full_name%TYPE; --bug 15957689

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);
2651: l_revision_buyer per_all_people_f.full_name%TYPE; --bug 15957689
2652:
2653: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

Line 2651: l_revision_buyer per_all_people_f.full_name%TYPE; --bug 15957689

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);
2651: l_revision_buyer per_all_people_f.full_name%TYPE; --bug 15957689
2652:
2653: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
2654: l_ship_via_lookup_desc ORG_FREIGHT_TL.FREIGHT_CODE_TL%TYPE;
2655: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE;

Line 2915: from per_all_people_f

2911: if (l_deliver_to_id <> 0) then
2912: begin
2913: select full_name,work_telephone,email_address
2914: into l_deliver_to_person,l_phone,l_email_address
2915: from per_all_people_f
2916: where person_id = l_deliver_to_id
2917: and effective_start_date <= sysdate
2918: and effective_end_date >= sysdate;
2919: exception

Line 3236: from per_all_people_f

3232: if (l_deliver_to_id <> 0) then
3233: begin
3234: select full_name,work_telephone,email_address
3235: into l_deliver_to_person,l_phone,l_email_address
3236: from per_all_people_f
3237: where person_id = l_deliver_to_id
3238: and effective_start_date <= sysdate
3239: and effective_end_date >= sysdate;
3240: exception

Line 3740: from per_all_people_f --

3736:
3737: if (l_po_revision = 0) then
3738:
3739: select full_name into l_buyer
3740: from per_all_people_f --
3741: where person_id = (select agent_id from po_headers
3742: where po_header_id = to_number(l_po_header_id))
3743: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3744:

Line 3747: from per_all_people_f --

3743: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3744:
3745: else
3746: select full_name into l_buyer
3747: from per_all_people_f --
3748: where person_id = (select agent_id from po_headers_archive
3749: where po_header_id = to_number(l_po_header_id) and
3750: revision_num = 0)
3751: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502

Line 3763: from per_all_people_f --

3759:
3760: begin
3761: if (l_po_revision > 0) then
3762: select full_name into l_revision_buyer
3763: from per_all_people_f --
3764: where person_id = (select agent_id from po_headers_archive
3765: where po_header_id = to_number(l_po_header_id) and
3766: revision_num = l_po_revision)
3767: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502

Line 3781: from per_all_people_f --

3777: -- there will be an entry in this table regardless of whether there is a revision
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

Line 3795: from per_all_people_f --

3791:
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