APPS.OE_VALUE_TO_ID dependencies on DUAL

Line 561: SELECT in_sold_to_org_id FROM DUAL

557: AND STATUS = 'A'
558: AND ADDRESS_STATUS ='A' --bug 2752321
559: AND CUSTOMER_ID IN
560: (
561: SELECT in_sold_to_org_id FROM DUAL
562: UNION
563: SELECT CUST_ACCOUNT_ID FROM
564: HZ_CUST_ACCT_RELATE WHERE
565: RELATED_CUST_ACCOUNT_ID = in_sold_to_org_id

Line 753: --select userenv('CLIENT_INFO') into l_org from dual;

749: IF l_debug_level > 0 THEN
750: oe_debug_pub.add( 'NOT FOUND' ) ;
751: END IF;
752: l_org :=mo_global.get_current_org_id ; --MOAC
753: --select userenv('CLIENT_INFO') into l_org from dual;
754: IF l_debug_level > 0 THEN
755: oe_debug_pub.add( 'ORG='||L_ORG ) ;
756: END IF;
757:

Line 774: (SELECT l_sold_to_org_id FROM DUAL

770: NVL( p_deliver_to_address4, fnd_api.g_miss_char)
771: AND STATUS = 'A'
772: AND ADDRESS_STATUS ='A' --bug 2752321
773: AND CUSTOMER_ID IN
774: (SELECT l_sold_to_org_id FROM DUAL
775: UNION
776: SELECT CUST_ACCOUNT_ID FROM
777: HZ_CUST_ACCT_RELATE WHERE
778: RELATED_CUST_ACCOUNT_ID = l_sold_to_org_id

Line 1238: SELECT in_sold_to_org_id FROM DUAL

1234: AND STATUS = 'A'
1235: AND ADDRESS_STATUS ='A' --bug 2752321
1236: AND CUSTOMER_ID IN
1237: (
1238: SELECT in_sold_to_org_id FROM DUAL
1239: UNION
1240: SELECT CUST_ACCOUNT_ID FROM
1241: HZ_CUST_ACCT_RELATE WHERE
1242: RELATED_CUST_ACCOUNT_ID = in_sold_to_org_id

Line 1436: --select userenv('CLIENT_INFO') into l_org from dual;

1432: IF l_debug_level > 0 THEN
1433: oe_debug_pub.add( 'NOT FOUND' ) ;
1434: END IF;
1435: l_org :=mo_global.get_current_org_id ; --MOAC
1436: --select userenv('CLIENT_INFO') into l_org from dual;
1437: IF l_debug_level > 0 THEN
1438: oe_debug_pub.add( 'ORG='||L_ORG ) ;
1439: END IF;
1440: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID

Line 1456: (SELECT l_sold_to_org_id FROM DUAL

1452: NVL( p_invoice_to_address4, fnd_api.g_miss_char)
1453: AND STATUS = 'A'
1454: AND ADDRESS_STATUS ='A' --bug 2752321
1455: AND CUSTOMER_ID IN
1456: (SELECT l_sold_to_org_id FROM DUAL
1457: UNION
1458: SELECT CUST_ACCOUNT_ID FROM
1459: HZ_CUST_ACCT_RELATE WHERE
1460: RELATED_CUST_ACCOUNT_ID = l_sold_to_org_id

Line 2147: SELECT in_sold_to_org_id FROM DUAL

2143: nvl( p_ship_to_country, fnd_api.g_miss_char)
2144: AND STATUS = 'A'
2145: AND ADDRESS_STATUS ='A' --bug 2752321
2146: AND CUSTOMER_ID in(
2147: SELECT in_sold_to_org_id FROM DUAL
2148: UNION
2149: SELECT CUST_ACCOUNT_ID FROM
2150: HZ_CUST_ACCT_RELATE WHERE
2151: RELATED_CUST_ACCOUNT_ID = in_sold_to_org_id

Line 2355: SELECT l_sold_to_org_id FROM DUAL

2351: AND STATUS = 'A'
2352: AND ADDRESS_STATUS ='A' --bug 2752321
2353: AND CUSTOMER_ID
2354: in (
2355: SELECT l_sold_to_org_id FROM DUAL
2356: UNION
2357: SELECT CUST_ACCOUNT_ID FROM
2358: HZ_CUST_ACCT_RELATE WHERE
2359: RELATED_CUST_ACCOUNT_ID = l_sold_to_org_id