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_OTM_INTEGRATION_PVT dependencies on HR_GENERAL

Line 752: , HR_GENERAL.get_phone_number(

748: , plla.ship_to_location_id
749: , hrl.location_code ship_to_location_code
750: , TRIM(ppf.first_name || ' ' || ppf.last_name) ship_to_contact_name
751: , ppf.email_address ship_to_contact_email
752: , HR_GENERAL.get_phone_number(
753: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
754: , HR_GENERAL.get_phone_number(
755: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
756: FROM po_headers_archive_all poha

Line 754: , HR_GENERAL.get_phone_number(

750: , TRIM(ppf.first_name || ' ' || ppf.last_name) ship_to_contact_name
751: , ppf.email_address ship_to_contact_email
752: , HR_GENERAL.get_phone_number(
753: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
754: , HR_GENERAL.get_phone_number(
755: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
756: FROM po_headers_archive_all poha
757: , po_lines_archive_all pola
758: , po_line_locations_archive_all plla

Line 849: , hr_general.get_phone_number(poha.agent_id, 'W1', SYSDATE)

845: , hrl.location_id
846: , hrl.location_code
847: , ppf.first_name
848: , ppf.last_name
849: , hr_general.get_phone_number(poha.agent_id, 'W1', SYSDATE)
850: , ppf.email_address
851: , hr_general.get_phone_number(poha.agent_id, 'WF', SYSDATE)
852: , poha.bill_to_location_id
853: , hrl2.location_code

Line 851: , hr_general.get_phone_number(poha.agent_id, 'WF', SYSDATE)

847: , ppf.first_name
848: , ppf.last_name
849: , hr_general.get_phone_number(poha.agent_id, 'W1', SYSDATE)
850: , ppf.email_address
851: , hr_general.get_phone_number(poha.agent_id, 'WF', SYSDATE)
852: , poha.bill_to_location_id
853: , hrl2.location_code
854: , apt.name -- terms
855: INTO x_otm_doc.po_header_id

Line 1505: , HR_GENERAL.get_phone_number(

1501: , plla.ship_to_location_id
1502: , hrl.location_code ship_to_location_code
1503: , TRIM(ppf.first_name || ' ' || ppf.last_name) ship_to_contact_name
1504: , ppf.email_address ship_to_contact_email
1505: , HR_GENERAL.get_phone_number(
1506: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
1507: , HR_GENERAL.get_phone_number(
1508: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
1509: FROM po_headers_archive_all poha

Line 1507: , HR_GENERAL.get_phone_number(

1503: , TRIM(ppf.first_name || ' ' || ppf.last_name) ship_to_contact_name
1504: , ppf.email_address ship_to_contact_email
1505: , HR_GENERAL.get_phone_number(
1506: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
1507: , HR_GENERAL.get_phone_number(
1508: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
1509: FROM po_headers_archive_all poha
1510: , po_releases_archive_all pora
1511: , po_lines_archive_all pola

Line 1609: , hr_general.get_phone_number(poha.agent_id, 'W1', SYSDATE)

1605: , hrl.location_id
1606: , hrl.location_code
1607: , ppf.first_name
1608: , ppf.last_name
1609: , hr_general.get_phone_number(poha.agent_id, 'W1', SYSDATE)
1610: , ppf.email_address
1611: , hr_general.get_phone_number(poha.agent_id, 'WF', SYSDATE)
1612: , poha.bill_to_location_id
1613: , hrl2.location_code

Line 1611: , hr_general.get_phone_number(poha.agent_id, 'WF', SYSDATE)

1607: , ppf.first_name
1608: , ppf.last_name
1609: , hr_general.get_phone_number(poha.agent_id, 'W1', SYSDATE)
1610: , ppf.email_address
1611: , hr_general.get_phone_number(poha.agent_id, 'WF', SYSDATE)
1612: , poha.bill_to_location_id
1613: , hrl2.location_code
1614: , apt.name -- terms
1615: INTO x_otm_doc.po_header_id