DBA Data[Home] [Help]

APPS.PO_OTM_INTEGRATION_PVT dependencies on HR_GENERAL

Line 822: , HR_GENERAL.get_phone_number(

818: , plla.ship_to_location_id
819: , hrl.location_code ship_to_location_code
820: , TRIM(ppf.first_name || ' ' || ppf.last_name) ship_to_contact_name
821: , ppf.email_address ship_to_contact_email
822: , HR_GENERAL.get_phone_number(
823: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
824: , HR_GENERAL.get_phone_number(
825: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
826: FROM po_headers_archive_all poha

Line 824: , HR_GENERAL.get_phone_number(

820: , TRIM(ppf.first_name || ' ' || ppf.last_name) ship_to_contact_name
821: , ppf.email_address ship_to_contact_email
822: , HR_GENERAL.get_phone_number(
823: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
824: , HR_GENERAL.get_phone_number(
825: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
826: FROM po_headers_archive_all poha
827: , po_lines_archive_all pola
828: , po_line_locations_archive_all plla

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

915: , hrl.location_id
916: , hrl.location_code
917: , ppf.first_name
918: , ppf.last_name
919: , hr_general.get_phone_number(poha.agent_id, 'W1', SYSDATE)
920: , ppf.email_address
921: , hr_general.get_phone_number(poha.agent_id, 'WF', SYSDATE)
922: , poha.bill_to_location_id
923: , hrl2.location_code

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

917: , ppf.first_name
918: , ppf.last_name
919: , hr_general.get_phone_number(poha.agent_id, 'W1', SYSDATE)
920: , ppf.email_address
921: , hr_general.get_phone_number(poha.agent_id, 'WF', SYSDATE)
922: , poha.bill_to_location_id
923: , hrl2.location_code
924: , apt.name -- terms
925: INTO x_otm_doc.po_header_id

Line 1577: , HR_GENERAL.get_phone_number(

1573: , plla.ship_to_location_id
1574: , hrl.location_code ship_to_location_code
1575: , TRIM(ppf.first_name || ' ' || ppf.last_name) ship_to_contact_name
1576: , ppf.email_address ship_to_contact_email
1577: , HR_GENERAL.get_phone_number(
1578: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
1579: , HR_GENERAL.get_phone_number(
1580: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
1581: FROM po_headers_archive_all poha

Line 1579: , HR_GENERAL.get_phone_number(

1575: , TRIM(ppf.first_name || ' ' || ppf.last_name) ship_to_contact_name
1576: , ppf.email_address ship_to_contact_email
1577: , HR_GENERAL.get_phone_number(
1578: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
1579: , HR_GENERAL.get_phone_number(
1580: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
1581: FROM po_headers_archive_all poha
1582: , po_releases_archive_all pora
1583: , po_lines_archive_all pola

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

1677: , hrl.location_id
1678: , hrl.location_code
1679: , ppf.first_name
1680: , ppf.last_name
1681: , hr_general.get_phone_number(poha.agent_id, 'W1', SYSDATE)
1682: , ppf.email_address
1683: , hr_general.get_phone_number(poha.agent_id, 'WF', SYSDATE)
1684: , poha.bill_to_location_id
1685: , hrl2.location_code

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

1679: , ppf.first_name
1680: , ppf.last_name
1681: , hr_general.get_phone_number(poha.agent_id, 'W1', SYSDATE)
1682: , ppf.email_address
1683: , hr_general.get_phone_number(poha.agent_id, 'WF', SYSDATE)
1684: , poha.bill_to_location_id
1685: , hrl2.location_code
1686: , apt.name -- terms
1687: INTO x_otm_doc.po_header_id