APPS.OE_VALIDATE_LINE dependencies on HZ_CUST_ACCT_RELATE_ALL

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