APPS.OE_VALIDATE_LINE dependencies on HZ_CUST_ACCT_RELATE

Line 2441: HZ_CUST_ACCT_RELATE_ALL h WHERE

2437: ACCT_SITE.CUST_ACCOUNT_ID in (
2438: SELECT p_sold_to_org_id FROM DUAL
2439: UNION
2440: SELECT CUST_ACCOUNT_ID FROM
2441: HZ_CUST_ACCT_RELATE_ALL h WHERE
2442: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
2443: and h.org_id=acct_site.org_id
2444: and ship_to_flag = 'Y' and status = 'A')
2445: --bug 4205113

Line 2523: HZ_CUST_ACCT_RELATE_ALL h WHERE

2519: ACCT_SITE.CUST_ACCOUNT_ID in (
2520: SELECT p_sold_to_org_id FROM DUAL
2521: UNION
2522: SELECT CUST_ACCOUNT_ID FROM
2523: HZ_CUST_ACCT_RELATE_ALL h WHERE
2524: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
2525: and h.org_id=acct_site.org_id
2526: and ship_to_flag = 'Y' and status='A')
2527: -- bug 4205113

Line 2619: from hz_cust_acct_relate

2615: in (select to_number(p_line_rec.sold_to_org_id )
2616: from sys.dual
2617: union
2618: select cust_account_id customer_id
2619: from hz_cust_acct_relate
2620: where related_cust_account_id = p_line_rec.sold_to_org_id
2621: and status = 'A')
2622:
2623: and ratrx.invoice_currency_code = p_hdr_currency_code

Line 2642: from hz_cust_acct_relate_all h

2638: (select p_line_rec.sold_to_org_id
2639: from sys.dual
2640: union
2641: select cust_account_id customer_id
2642: from hz_cust_acct_relate_all h
2643: where related_cust_account_id = p_line_rec.sold_to_org_id
2644: and status = 'A'
2645: and bill_to_flag = 'Y'
2646: and h.org_id =ratrx.org_id

Line 2656: from hz_cust_acct_relate_all c,

2652: and su.site_use_id = p_line_rec.invoice_to_org_id
2653: and cas.org_id=ratrx.org_id
2654: union
2655: select c.cust_account_id customer_id
2656: from hz_cust_acct_relate_all c,
2657: hz_cust_site_uses_all su,
2658: hz_cust_acct_sites_all cas
2659: where cas.cust_acct_site_id = su.cust_acct_site_id
2660: and su.site_use_id = p_line_rec.invoice_to_org_id

Line 3391: FROM HZ_CUST_ACCT_RELATE

3387: if lcustomer_relations = 'Y' then
3388: begin
3389: SELECT 'Y'
3390: INTO l_exists
3391: FROM HZ_CUST_ACCT_RELATE
3392: WHERE RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id
3393: AND CUST_ACCOUNT_ID = l_sold_to_org_id
3394: AND STATUS = 'A'
3395: AND ROWNUM = 1;

Line 5859: HZ_CUST_ACCT_RELATE_ALL h WHERE

5855: ACCT_SITE.CUST_ACCOUNT_ID in (
5856: SELECT p_line_rec.sold_to_org_id FROM DUAL
5857: UNION
5858: SELECT CUST_ACCOUNT_ID FROM
5859: HZ_CUST_ACCT_RELATE_ALL h WHERE
5860: RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id
5861: and h.org_id=acct_site.org_id
5862: and bill_to_flag = 'Y' and status='A')
5863: --bug 4205113

Line 6479: hz_cust_acct_relate where

6475: INTO l_dummy
6476: FROM dual
6477: WHERE exists(
6478: select 'x' from
6479: hz_cust_acct_relate where
6480: related_cust_account_id = p_line_rec.sold_to_org_id
6481: and status = 'A'
6482: AND cust_account_id = l_sold_to_org
6483: );

Line 6675: from hz_cust_acct_relate r

6671: select p_line_rec.sold_to_org_id
6672: from dual
6673: union
6674: select r.cust_account_id
6675: from hz_cust_acct_relate r
6676: where r.related_cust_account_id = p_line_rec.sold_to_org_id);
6677: END IF;
6678: END IF;
6679: