APPS.OE_VALUE_TO_ID dependencies on HZ_CUST_ACCT_RELATE

Line 564: HZ_CUST_ACCT_RELATE WHERE

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
566: and ship_to_flag = 'Y' and status='A');
567: CURSOR C2 IS
568: SELECT ORGANIZATION_ID

Line 657: FROM hz_cust_acct_relate

653:
654: BEGIN
655: SELECT 1
656: INTO l_dummy
657: FROM hz_cust_acct_relate
658: WHERE cust_account_id = l_deliver_to_customer_id
659: AND related_cust_account_id = l_sold_to_org_id
660: and ship_to_flag = 'Y' and status='A';
661: EXCEPTION

Line 777: HZ_CUST_ACCT_RELATE WHERE

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
779: and ship_to_flag = 'Y' and status='A');
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add( 'AFTER SELECT FOUND='||L_ID ) ;

Line 1241: HZ_CUST_ACCT_RELATE WHERE

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
1243: and bill_to_flag = 'Y' and status='A');
1244: CURSOR C2 IS
1245: SELECT ORGANIZATION_ID

Line 1335: FROM hz_cust_acct_relate

1331:
1332: BEGIN
1333: SELECT 1
1334: INTO l_dummy
1335: FROM hz_cust_acct_relate
1336: WHERE cust_account_id = l_invoice_to_customer_id
1337: AND related_cust_account_id = l_sold_to_org_id and
1338: bill_to_flag ='Y' and status='A';
1339:

Line 1459: HZ_CUST_ACCT_RELATE WHERE

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
1461: and bill_to_flag = 'Y' and status='A');
1462: IF l_debug_level > 0 THEN
1463: oe_debug_pub.add( 'AFTER SELECT FOUND='||L_ID ) ;

Line 2150: HZ_CUST_ACCT_RELATE WHERE

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
2152: and ship_to_flag = 'Y' and status='A');
2153:
2154: CURSOR C2 IS

Line 2246: FROM hz_cust_acct_relate

2242:
2243: BEGIN
2244: SELECT 1
2245: INTO l_dummy
2246: FROM hz_cust_acct_relate
2247: WHERE cust_account_id = l_ship_to_customer_id
2248: AND related_cust_account_id = l_sold_to_org_id
2249: and ship_to_flag='Y' and status='A';
2250: EXCEPTION

Line 2358: HZ_CUST_ACCT_RELATE WHERE

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
2360: and ship_to_flag = 'Y' and status='A');
2361:
2362: END IF;