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_VALUE_TO_ID dependencies on HZ_CUST_ACCOUNTS

Line 2564: HZ_CUST_ACCOUNTS CUST_ACCT

2560: WHERE NAME = p_site_customer;*/
2561:
2562: SELECT CUST_ACCT.CUST_ACCOUNT_ID INTO l_id
2563: FROM HZ_PARTIES PARTY,
2564: HZ_CUST_ACCOUNTS CUST_ACCT
2565: WHERE CUST_ACCT.PARTY_ID=PARTY.PARTY_ID
2566: AND PARTY.PARTY_NAME = p_site_customer
2567: AND CUST_ACCT.status ='A'; -- added for bug 3651505
2568:

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

2635: /*SELECT ORGANIZATION_ID
2636: INTO l_id
2637: FROM OE_SOLD_TO_ORGS_V
2638: WHERE NAME = p_sold_to_org;*/
2639: Select Cust_Acct.Cust_account_id into l_id from HZ_CUST_ACCOUNTS Cust_Acct,
2640: HZ_PARTIES Party where Cust_Acct.Party_id = Party.party_id and
2641: Party.Party_name = p_sold_to_org
2642: AND cust_acct.status='A'; -- added for 3651505
2643:

Line 6327: from HZ_CUST_ACCOUNTS Cust_Acct,

6323: WHERE CUSTOMER_NUMBER = p_end_customer_number;
6324: ELSE
6325: Select Cust_Acct.Cust_account_id
6326: into l_id
6327: from HZ_CUST_ACCOUNTS Cust_Acct,
6328: HZ_PARTIES Party
6329: where Cust_Acct.Party_id = Party.party_id
6330: and Party.Party_name = p_end_customer;
6331: