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.CS_STD dependencies on HZ_PARTY_SITES

Line 956: and owner_table_name ='HZ_PARTY_SITES'

952: into l_phone
953: from (select phone_number, phone_area_code, phone_country_code
954: from hz_contact_points
955: where owner_table_id = party_id
956: and owner_table_name ='HZ_PARTY_SITES'
957: and contact_point_type = 'PHONE'
958: order by primary_flag desc, creation_date asc)
959: where rownum = 1;
960:

Line 981: and owner_table_name ='HZ_PARTY_SITES'

977: from (select reverse(TRANSPOSED_PHONE_NUMBER)
978: TRANSPOSED_PHONE_NUMBER
979: from hz_contact_points
980: where owner_table_id = party_id
981: and owner_table_name ='HZ_PARTY_SITES'
982: and contact_point_type = 'PHONE'
983: order by primary_flag desc, creation_date asc)
984: where rownum = 1;
985:

Line 1004: from hz_party_sites

1000: addrswitch varchar2(100);
1001: begin
1002: select
1003: decode(created_by_module,'SR_ONETIME' ,'UnValidAddrXRN','ValidXAddrRN') into addrswitch
1004: from hz_party_sites
1005: where party_site_id = incident_location_id;
1006:
1007: return(addrswitch);
1008: exception when others then