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

Line 165: from hz_cust_acct_sites st, hz_cust_site_uses_all su

161: lcustomer_relations varchar2(1);
162: l_orgid number;
163: Begin
164: select su.org_id into l_orgid
165: from hz_cust_acct_sites st, hz_cust_site_uses_all su
166: where st.cust_acct_site_id = p_address_id
167: and su.cust_acct_site_id = st.cust_acct_site_id
168: and su.site_use_code= 'SHIP_TO' and rownum =1;
169: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_orgid);

Line 209: from hz_cust_acct_sites st, hz_cust_site_uses_all su

205: lcustomer_relations varchar2(1);
206: l_orgid number;
207: Begin
208: select su.org_id into l_orgid
209: from hz_cust_acct_sites st, hz_cust_site_uses_all su
210: where st.cust_acct_site_id = p_address_id
211: and su.cust_acct_site_id = st.cust_acct_site_id
212: and su.site_use_code= 'BILL_TO' and rownum =1;
213: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_orgid);