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.CSI_SYSTEMS_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 4982: FROM hz_cust_site_uses_all--hz_party_sites

4978: THEN
4979: BEGIN
4980: SELECT 'x'
4981: INTO l_dummy
4982: FROM hz_cust_site_uses_all--hz_party_sites
4983: WHERE site_use_id = p_ship_to_site_use_id
4984: AND site_use_code = 'SHIP_TO';
4985: EXCEPTION
4986: WHEN no_data_found THEN

Line 4999: FROM hz_cust_site_uses_all --hz_party_sites

4995: THEN
4996: BEGIN
4997: SELECT 'x'
4998: INTO l_dummy
4999: FROM hz_cust_site_uses_all --hz_party_sites
5000: WHERE site_use_id = p_ship_to_site_use_id
5001: AND site_use_code = 'SHIP_TO';
5002: EXCEPTION
5003: WHEN no_data_found THEN

Line 5049: FROM hz_cust_site_uses_all --hz_cust_acct_sites_all

5045: THEN
5046: BEGIN
5047: SELECT 'x'
5048: INTO l_dummy
5049: FROM hz_cust_site_uses_all --hz_cust_acct_sites_all
5050: WHERE site_use_id = p_bill_to_site_use_id
5051: AND site_use_code = 'BILL_TO';
5052: EXCEPTION
5053: WHEN no_data_found THEN

Line 5066: FROM hz_cust_site_uses_all --hz_cust_acct_sites_all

5062: THEN
5063: BEGIN
5064: SELECT 'x'
5065: INTO l_dummy
5066: FROM hz_cust_site_uses_all --hz_cust_acct_sites_all
5067: WHERE site_use_id = p_bill_to_site_use_id
5068: AND site_use_code = 'BILL_TO';
5069: EXCEPTION
5070: WHEN no_data_found THEN

Line 5876: FROM HZ_CUST_SITE_USES_ALL hzsu

5872: ,p_system_header_tbl(sys_row).ship_country
5873: ,p_system_header_tbl(sys_row).ship_description
5874: ,p_system_header_tbl(sys_row).ship_to_location_id
5875: ,p_system_header_tbl(sys_row).ship_to_site_number
5876: FROM HZ_CUST_SITE_USES_ALL hzsu
5877: ,HZ_CUST_ACCT_SITES_ALL hzca
5878: ,HZ_PARTY_SITES hps
5879: ,HZ_PARTIES hzp
5880: ,HZ_LOCATIONS hls

Line 5925: FROM HZ_CUST_SITE_USES_ALL hzsu

5921: ,p_system_header_tbl(sys_row).bill_country
5922: ,p_system_header_tbl(sys_row).bill_description
5923: ,p_system_header_tbl(sys_row).bill_to_location_id
5924: ,p_system_header_tbl(sys_row).bill_to_site_number
5925: FROM HZ_CUST_SITE_USES_ALL hzsu
5926: ,HZ_CUST_ACCT_SITES_ALL hzca
5927: ,HZ_PARTY_SITES hps
5928: ,HZ_PARTIES hzp
5929: ,HZ_LOCATIONS hls