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 5195: l_buyer_name hr_all_organization_units_tl.name%TYPE;

5191: l_po_num po_headers_all.segment1%TYPE;
5192: l_blanket_num po_headers_all.segment1%TYPE;
5193: --l_release_num number;
5194: l_release_num po_releases_all.release_num%TYPE;
5195: l_buyer_name hr_all_organization_units_tl.name%TYPE;
5196: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5197: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
5198: l_doc_hdr_info varchar2(2000);
5199:

Line 5268: hr_all_organization_units_tl hou,

5264: l_type_lookup_code,
5265: l_global_agreement_flag,
5266: l_display_name
5267: from po_headers_all pha,
5268: hr_all_organization_units_tl hou,
5269: PO_ALL_DOC_STYLE_LINES PDSL
5270: where pha.po_header_id = l_header_id
5271: and pha.org_id = hou.organization_id(+)
5272: and hou.language(+) = userenv('LANG')

Line 5312: hr_all_organization_units_tl hou

5308: l_buyer_name,
5309: l_type_lookup_code
5310: from po_headers_all pha,
5311: po_releases_all pra,
5312: hr_all_organization_units_tl hou
5313: where pra.po_release_id = l_release_id
5314: and pha.po_header_id = pra.po_header_id
5315: and pha.org_id = hou.organization_id(+)
5316: and hou.language(+) = userenv('LANG');

Line 6025: l_buyer_name hr_all_organization_units_tl.name%TYPE;

6021: l_supplier_username fnd_user.user_name%TYPE;
6022: l_blanket_num po_headers_all.segment1%TYPE;
6023: --l_release_num number;
6024: l_release_num po_releases_all.release_num%TYPE;
6025: l_buyer_name hr_all_organization_units_tl.name%TYPE;
6026: l_po_num po_headers_all.segment1%TYPE;
6027: l_revision_num number;
6028: l_revision_num2 number;
6029: l_notification_subject varchar2(2000);

Line 6166: hr_all_organization_units_tl hou

6162: l_vendor_id,
6163: l_acceptance_required_flag
6164: from po_headers_all pha,
6165: po_releases_all pra,
6166: hr_all_organization_units_tl hou
6167: where pra.po_release_id = l_document_id
6168: and pha.po_header_id = pra.po_header_id
6169: and pha.org_id = hou.organization_id(+)
6170: and hou.language(+) = userenv('LANG');

Line 6265: hr_all_organization_units_tl hou

6261: l_global_agreement_flag,
6262: l_vendor_id,
6263: l_acceptance_required_flag
6264: from po_headers_all pha,
6265: hr_all_organization_units_tl hou
6266: where pha.po_header_id = l_document_id
6267: and pha.org_id = hou.organization_id(+)
6268: and hou.language(+) = userenv('LANG');
6269:

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

6844:
6845: --l_po_num po_headers_all.segment1%TYPE;
6846: --l_blanket_num po_headers_all.segment1%TYPE;
6847: --l_release_num number;
6848: --l_buyer_name hr_all_organization_units_tl.name%TYPE;
6849: --l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
6850: --l_document_type varchar2(2000);
6851: l_buyer_agent_id number;
6852: l_responded_by_id number;