APPS.OE_VALIDATE_LINE dependencies on HZ_CUST_ACCT_RELATE

Line 2316: HZ_CUST_ACCT_RELATE_ALL h WHERE

2312: ACCT_SITE.CUST_ACCOUNT_ID in (
2313: SELECT p_sold_to_org_id FROM DUAL
2314: UNION
2315: SELECT CUST_ACCOUNT_ID FROM
2316: HZ_CUST_ACCT_RELATE_ALL h WHERE
2317: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
2318: and h.org_id=acct_site.org_id
2319: and ship_to_flag = 'Y' and status = 'A')
2320: --bug 4205113

Line 2398: HZ_CUST_ACCT_RELATE_ALL h WHERE

2394: ACCT_SITE.CUST_ACCOUNT_ID in (
2395: SELECT p_sold_to_org_id FROM DUAL
2396: UNION
2397: SELECT CUST_ACCOUNT_ID FROM
2398: HZ_CUST_ACCT_RELATE_ALL h WHERE
2399: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
2400: and h.org_id=acct_site.org_id
2401: and ship_to_flag = 'Y' and status='A')
2402: -- bug 4205113

Line 2494: from hz_cust_acct_relate

2490: in (select to_number(p_line_rec.sold_to_org_id )
2491: from sys.dual
2492: union
2493: select cust_account_id customer_id
2494: from hz_cust_acct_relate
2495: where related_cust_account_id = p_line_rec.sold_to_org_id
2496: and status = 'A')
2497:
2498: and ratrx.invoice_currency_code = p_hdr_currency_code

Line 2517: from hz_cust_acct_relate_all h

2513: (select p_line_rec.sold_to_org_id
2514: from sys.dual
2515: union
2516: select cust_account_id customer_id
2517: from hz_cust_acct_relate_all h
2518: where related_cust_account_id = p_line_rec.sold_to_org_id
2519: and status = 'A'
2520: and bill_to_flag = 'Y'
2521: and h.org_id =ratrx.org_id

Line 2531: from hz_cust_acct_relate_all c,

2527: and su.site_use_id = p_line_rec.invoice_to_org_id
2528: and cas.org_id=ratrx.org_id
2529: union
2530: select c.cust_account_id customer_id
2531: from hz_cust_acct_relate_all c,
2532: hz_cust_site_uses_all su,
2533: hz_cust_acct_sites_all cas
2534: where cas.cust_acct_site_id = su.cust_acct_site_id
2535: and su.site_use_id = p_line_rec.invoice_to_org_id

Line 3266: FROM HZ_CUST_ACCT_RELATE

3262: if lcustomer_relations = 'Y' then
3263: begin
3264: SELECT 'Y'
3265: INTO l_exists
3266: FROM HZ_CUST_ACCT_RELATE
3267: WHERE RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id
3268: AND CUST_ACCOUNT_ID = l_sold_to_org_id
3269: AND STATUS = 'A'
3270: AND ROWNUM = 1;

Line 5518: HZ_CUST_ACCT_RELATE_ALL h WHERE

5514: ACCT_SITE.CUST_ACCOUNT_ID in (
5515: SELECT p_line_rec.sold_to_org_id FROM DUAL
5516: UNION
5517: SELECT CUST_ACCOUNT_ID FROM
5518: HZ_CUST_ACCT_RELATE_ALL h WHERE
5519: RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id
5520: and h.org_id=acct_site.org_id
5521: and bill_to_flag = 'Y' and status='A')
5522: --bug 4205113

Line 6107: hz_cust_acct_relate where

6103: INTO l_dummy
6104: FROM dual
6105: WHERE exists(
6106: select 'x' from
6107: hz_cust_acct_relate where
6108: related_cust_account_id = p_line_rec.sold_to_org_id
6109: and status = 'A'
6110: AND cust_account_id = l_sold_to_org
6111: );

Line 6303: from hz_cust_acct_relate r

6299: select p_line_rec.sold_to_org_id
6300: from dual
6301: union
6302: select r.cust_account_id
6303: from hz_cust_acct_relate r
6304: where r.related_cust_account_id = p_line_rec.sold_to_org_id);
6305: END IF;
6306: END IF;
6307: