APPS.OE_CNCL_VALUE_TO_ID dependencies on DUAL

Line 358: SELECT p_sold_to_org_id FROM DUAL

354: nvl( p_deliver_to_country, fnd_api.g_miss_char)
355: --AND STATUS = 'A'
356: AND CUSTOMER_ID IN
357: (
358: SELECT p_sold_to_org_id FROM DUAL
359: UNION
360: SELECT CUST_ACCOUNT_ID FROM
361: HZ_CUST_ACCT_RELATE WHERE
362: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

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

448: ELSE
449: IF l_debug_level > 0 THEN
450: oe_debug_pub.add( 'NOT FOUND' ) ;
451: END IF;
452: -- select userenv('CLIENT_INFO') into l_org from dual;
453: l_org := MO_GLOBAL.Get_Current_Org_Id; --moac
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add( 'ORG='||L_ORG ) ;
456: END IF;

Line 473: (SELECT p_sold_to_org_id FROM DUAL

469: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
470: NVL( p_deliver_to_address4, fnd_api.g_miss_char)
471: -- AND STATUS = 'A'
472: AND CUSTOMER_ID IN
473: (SELECT p_sold_to_org_id FROM DUAL
474: UNION
475: SELECT CUST_ACCOUNT_ID FROM
476: HZ_CUST_ACCT_RELATE WHERE
477: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 1036: SELECT p_sold_to_org_id FROM DUAL

1032: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1033: AND STATUS = 'A'
1034: AND CUSTOMER_ID IN
1035: (
1036: SELECT p_sold_to_org_id FROM DUAL
1037: UNION
1038: SELECT CUST_ACCOUNT_ID FROM
1039: HZ_CUST_ACCT_RELATE WHERE
1040: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 1135: (SELECT p_sold_to_org_id FROM DUAL

1131: DECODE(COUNTRY, NULL, NULL, COUNTRY) =
1132: NVL( p_invoice_to_address4, fnd_api.g_miss_char)
1133: AND STATUS = 'A'
1134: AND CUSTOMER_ID IN
1135: (SELECT p_sold_to_org_id FROM DUAL
1136: UNION
1137: SELECT CUST_ACCOUNT_ID FROM
1138: HZ_CUST_ACCT_RELATE WHERE
1139: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 1893: SELECT p_sold_to_org_id FROM DUAL

1889: AND nvl( country, fnd_api.g_miss_char) =
1890: nvl( p_ship_to_country, fnd_api.g_miss_char)
1891: AND STATUS = 'A'
1892: AND CUSTOMER_ID in(
1893: SELECT p_sold_to_org_id FROM DUAL
1894: UNION
1895: SELECT CUST_ACCOUNT_ID FROM
1896: HZ_CUST_ACCT_RELATE WHERE
1897: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 1987: SELECT p_sold_to_org_id FROM DUAL

1983: nvl( p_ship_to_address4, fnd_api.g_miss_char)
1984: AND STATUS = 'A'
1985: AND CUSTOMER_ID
1986: in (
1987: SELECT p_sold_to_org_id FROM DUAL
1988: UNION
1989: SELECT CUST_ACCOUNT_ID FROM
1990: HZ_CUST_ACCT_RELATE WHERE
1991: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id