APPS.OE_VALUE_TO_ID dependencies on OE_SOLD_TO_ORGS_V

Line 2542: FROM OE_SOLD_TO_ORGS_V

2538:
2539:
2540: SELECT ORGANIZATION_ID
2541: INTO l_id
2542: FROM OE_SOLD_TO_ORGS_V
2543: WHERE CUSTOMER_NUMBER = p_site_customer_number
2544: AND status='A'; -- added for bug 3651505
2545:
2546: IF l_debug_level > 0 THEN

Line 2559: FROM OE_SOLD_TO_ORGS_V

2555:
2556: --Bug 3631191
2557: /* SELECT ORGANIZATION_ID
2558: INTO l_id
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,

Line 2630: FROM OE_SOLD_TO_ORGS_V

2626:
2627: IF nvl(p_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
2628: SELECT ORGANIZATION_ID
2629: INTO l_id
2630: FROM OE_SOLD_TO_ORGS_V
2631: WHERE CUSTOMER_NUMBER = p_customer_number --added for 3651505
2632: AND status = 'A';
2633: ELSE
2634:

Line 2637: FROM OE_SOLD_TO_ORGS_V

2633: ELSE
2634:
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

Line 6322: FROM OE_SOLD_TO_ORGS_V

6318:
6319: IF nvl(p_end_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
6320: SELECT ORGANIZATION_ID
6321: INTO l_id
6322: FROM OE_SOLD_TO_ORGS_V
6323: WHERE CUSTOMER_NUMBER = p_end_customer_number;
6324: ELSE
6325: Select Cust_Acct.Cust_account_id
6326: into l_id