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_PARTIES

Line 2563: FROM HZ_PARTIES PARTY,

2559: FROM OE_SOLD_TO_ORGS_V
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

Line 2640: HZ_PARTIES Party where Cust_Acct.Party_id = Party.party_id and

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:
2644: END IF;

Line 6328: HZ_PARTIES Party

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:
6332: END IF;