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 OE_SOLD_TO_ORGS_V

Line 2142: FROM OE_SOLD_TO_ORGS_V

2138: IF nvl(p_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
2139:
2140: SELECT ORGANIZATION_ID
2141: INTO l_id
2142: FROM OE_SOLD_TO_ORGS_V
2143: WHERE CUSTOMER_NUMBER = p_customer_number;
2144:
2145: ELSE
2146:

Line 2149: FROM OE_SOLD_TO_ORGS_V

2145: ELSE
2146:
2147: /* SELECT ORGANIZATION_ID
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

Line 5448: FROM OE_SOLD_TO_ORGS_V

5444:
5445: IF nvl(p_end_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
5446: SELECT ORGANIZATION_ID
5447: INTO l_id
5448: FROM OE_SOLD_TO_ORGS_V
5449: WHERE CUSTOMER_NUMBER = p_end_customer_number;
5450: ELSE
5451: Select Cust_Acct.Cust_account_id
5452: into l_id