APPS.OE_VALIDATE_LINE dependencies on HZ_CUST_ACCT_RELATE_ALL

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 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 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