APPS.OE_CNCL_VALIDATE_HEADER dependencies on HZ_CUST_ACCT_RELATE

Line 333: HZ_CUST_ACCT_RELATE hcar

329: FROM oe_ship_to_orgs_v osov
330: WHERE site_use_id = p_header_rec.ship_to_org_id
331: AND EXISTS
332: (SELECT 1 FROM
333: HZ_CUST_ACCT_RELATE hcar
334: WHERE hcar.cust_account_id = osov.customer_id AND
335: hcar.related_cust_account_id = p_header_rec.sold_to_org_id
336: /* added the following condition to fix the bug 2002486 */
337: AND hcar.ship_to_flag = 'Y')

Line 354: HZ_CUST_ACCT_RELATE hcar WHERE

350: FROM oe_invoice_to_orgs_v oito
351: WHERE oito.site_use_id = p_header_rec.invoice_to_org_id
352: AND EXISTS(
353: SELECT 1 FROM
354: HZ_CUST_ACCT_RELATE hcar WHERE
355: hcar.cust_account_id = oito.customer_id AND
356: hcar.related_cust_account_id = p_header_rec.sold_to_org_id
357: AND hcar.bill_to_flag = 'Y')
358: AND ROWNUM = 1;

Line 738: HZ_CUST_ACCT_RELATE

734: customer_id in (
735: Select p_header_rec.sold_to_org_id from dual
736: union
737: select cust_account_id from
738: HZ_CUST_ACCT_RELATE
739: Where related_cust_account_id = p_header_rec.sold_to_org_id
740: /* added the following condition to fix the bug 2002486
741: and ship_to_flag = 'Y')*/
742:

Line 837: HZ_CUST_ACCT_RELATE_ALL R WHERE

833: AND ACCT_SITE.CUST_ACCOUNT_ID in (
834: SELECT p_header_rec.sold_to_org_id FROM DUAL
835: UNION
836: SELECT CUST_ACCOUNT_ID FROM
837: HZ_CUST_ACCT_RELATE_ALL R WHERE
838: R.ORG_ID = ACCT_SITE.ORG_ID
839: AND R.RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
840: and R.ship_to_flag = 'Y')
841: AND ROWNUM = 1;

Line 913: HZ_CUST_ACCT_RELATE where

909: customer_id in (
910: Select p_header_rec.sold_to_org_id from dual
911: union
912: select cust_account_id from
913: HZ_CUST_ACCT_RELATE where
914: related_cust_account_id = p_header_rec.sold_to_org_id
915: /* added the following condition to fix the bug 2002486
916: and bill_to_flag = 'Y')
917: