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_CHANGEORDERWF_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 5347: l_buyer_name hr_all_organization_units_tl.name%TYPE;

5343: l_po_num po_headers_all.segment1%TYPE;
5344: l_blanket_num po_headers_all.segment1%TYPE;
5345: --l_release_num number;
5346: l_release_num po_releases_all.release_num%TYPE;
5347: l_buyer_name hr_all_organization_units_tl.name%TYPE;
5348: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5349: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
5350: l_doc_hdr_info varchar2(2000);
5351:

Line 5422: hr_all_organization_units_tl hou,

5418: l_type_lookup_code,
5419: l_global_agreement_flag,
5420: l_display_name
5421: from po_headers_all pha,
5422: hr_all_organization_units_tl hou,
5423: PO_ALL_DOC_STYLE_LINES PDSL
5424: where pha.po_header_id = l_header_id
5425: and pha.org_id = hou.organization_id(+)
5426: and hou.language(+) = userenv('LANG')

Line 5466: hr_all_organization_units_tl hou

5462: l_buyer_name,
5463: l_type_lookup_code
5464: from po_headers_all pha,
5465: po_releases_all pra,
5466: hr_all_organization_units_tl hou
5467: where pra.po_release_id = l_release_id
5468: and pha.po_header_id = pra.po_header_id
5469: and pha.org_id = hou.organization_id(+)
5470: and hou.language(+) = userenv('LANG');

Line 6183: l_buyer_name hr_all_organization_units_tl.name%TYPE;

6179: l_supplier_username fnd_user.user_name%TYPE;
6180: l_blanket_num po_headers_all.segment1%TYPE;
6181: --l_release_num number;
6182: l_release_num po_releases_all.release_num%TYPE;
6183: l_buyer_name hr_all_organization_units_tl.name%TYPE;
6184: l_po_num po_headers_all.segment1%TYPE;
6185: l_revision_num number;
6186: l_revision_num2 number;
6187: l_notification_subject varchar2(2000);

Line 6324: hr_all_organization_units_tl hou

6320: l_vendor_id,
6321: l_acceptance_required_flag
6322: from po_headers_all pha,
6323: po_releases_all pra,
6324: hr_all_organization_units_tl hou
6325: where pra.po_release_id = l_document_id
6326: and pha.po_header_id = pra.po_header_id
6327: and pha.org_id = hou.organization_id(+)
6328: and hou.language(+) = userenv('LANG');

Line 6423: hr_all_organization_units_tl hou

6419: l_global_agreement_flag,
6420: l_vendor_id,
6421: l_acceptance_required_flag
6422: from po_headers_all pha,
6423: hr_all_organization_units_tl hou
6424: where pha.po_header_id = l_document_id
6425: and pha.org_id = hou.organization_id(+)
6426: and hou.language(+) = userenv('LANG');
6427:

Line 7006: --l_buyer_name hr_all_organization_units_tl.name%TYPE;

7002:
7003: --l_po_num po_headers_all.segment1%TYPE;
7004: --l_blanket_num po_headers_all.segment1%TYPE;
7005: --l_release_num number;
7006: --l_buyer_name hr_all_organization_units_tl.name%TYPE;
7007: --l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
7008: --l_document_type varchar2(2000);
7009: l_buyer_agent_id number;
7010: l_responded_by_id number;