APPS.OE_CNCL_VALUE_TO_ID dependencies on HZ_CUST_ACCT_RELATE

Line 361: HZ_CUST_ACCT_RELATE WHERE

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
363: and ship_to_flag = 'Y');
364: CURSOR C2 IS
365: SELECT ORGANIZATION_ID

Line 476: HZ_CUST_ACCT_RELATE WHERE

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
478: and ship_to_flag = 'Y');
479: IF l_debug_level > 0 THEN
480: oe_debug_pub.add( 'AFTER SELECT FOUND='||L_ID ) ;

Line 1039: HZ_CUST_ACCT_RELATE WHERE

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
1041: and bill_to_flag = 'Y');
1042: CURSOR C2 IS
1043: SELECT ORGANIZATION_ID

Line 1138: HZ_CUST_ACCT_RELATE WHERE

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
1140: and bill_to_flag = 'Y');
1141: END IF;
1142:

Line 1896: HZ_CUST_ACCT_RELATE WHERE

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
1898: and ship_to_flag = 'Y');
1899:
1900: CURSOR C2 IS

Line 1990: HZ_CUST_ACCT_RELATE WHERE

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
1992: and ship_to_flag = 'Y');
1993:
1994: END IF;