APPS.OE_VALIDATE_HEADER dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 563: FROM hz_cust_acct_relate_all hcar

559: select 'Y'
560: from ra_customer_trx ratrx
561: where ratrx.customer_trx_id = p_commitment_id
562: and exists (SELECT 1
563: FROM hz_cust_acct_relate_all hcar
564: WHERE hcar.cust_account_id = ratrx.bill_to_customer_id
565: and hcar.related_cust_account_id = p_sold_to_org_id
566: AND hcar.status = 'A'
567: and hcar.org_id = ratrx.org_id

Line 590: FROM hz_cust_acct_relate_all h

586: IN (SELECT p_sold_to_org_id
587: FROM sys.dual
588: UNION
589: SELECT cust_account_id customer_id
590: FROM hz_cust_acct_relate_all h
591: WHERE related_cust_account_id = p_sold_to_org_id
592: AND status = 'A'
593: and h.org_id = ratrx.org_id
594: AND bill_to_flag = 'Y')

Line 1691: HZ_CUST_ACCT_RELATE_ALL h WHERE

1687: ACCT_SITE.CUST_ACCOUNT_ID in (
1688: SELECT p_header_rec.sold_to_org_id FROM DUAL
1689: UNION
1690: SELECT CUST_ACCOUNT_ID FROM
1691: HZ_CUST_ACCT_RELATE_ALL h WHERE
1692: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
1693: and h.org_id =acct_site.org_id
1694: and ship_to_flag = 'Y' and status = 'A')
1695: --bug 4205113

Line 1787: HZ_CUST_ACCT_RELATE_ALL h WHERE

1783: ACCT_SITE.CUST_ACCOUNT_ID in (
1784: SELECT p_header_rec.sold_to_org_id FROM DUAL
1785: UNION
1786: SELECT CUST_ACCOUNT_ID FROM
1787: HZ_CUST_ACCT_RELATE_ALL h WHERE
1788: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
1789: and h.org_id =acct_site.org_id
1790: and ship_to_flag = 'Y' and status='A')
1791: --bug 4205113

Line 1885: HZ_CUST_ACCT_RELATE_ALL h WHERE

1881: ACCT_SITE.CUST_ACCOUNT_ID in (
1882: SELECT p_header_rec.sold_to_org_id FROM DUAL
1883: UNION
1884: SELECT CUST_ACCOUNT_ID FROM
1885: HZ_CUST_ACCT_RELATE_ALL h WHERE
1886: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
1887: and h.org_id =site.org_id
1888: and bill_to_flag = 'Y' and status='A' )
1889: --bug 4205113