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.OE_CNCL_VALUE_TO_ID dependencies on HZ_CUST_ACCOUNTS

Line 2152: Select Cust_Acct.Cust_account_id into l_id from HZ_CUST_ACCOUNTS Cust_Acct,

2148: INTO l_id
2149: FROM OE_SOLD_TO_ORGS_V
2150: WHERE NAME = p_sold_to_org;*/
2151:
2152: Select Cust_Acct.Cust_account_id into l_id from HZ_CUST_ACCOUNTS Cust_Acct,
2153: HZ_PARTIES Party where Cust_Acct.Party_id = Party.party_id and
2154: Party.Party_name = p_sold_to_org;
2155:
2156:

Line 5453: from HZ_CUST_ACCOUNTS Cust_Acct,

5449: WHERE CUSTOMER_NUMBER = p_end_customer_number;
5450: ELSE
5451: Select Cust_Acct.Cust_account_id
5452: into l_id
5453: from HZ_CUST_ACCOUNTS Cust_Acct,
5454: HZ_PARTIES Party
5455: where Cust_Acct.Party_id = Party.party_id
5456: and Party.Party_name = p_end_customer;
5457: