APPS.OE_CNCL_VALIDATE_HEADER dependencies on HZ_CUST_ACCT_RELATE

Line 332: HZ_CUST_ACCT_RELATE hcar

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

Line 353: HZ_CUST_ACCT_RELATE hcar WHERE

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

Line 707: HZ_CUST_ACCT_RELATE

703: customer_id in (
704: Select p_header_rec.sold_to_org_id from dual
705: union
706: select cust_account_id from
707: HZ_CUST_ACCT_RELATE
708: Where related_cust_account_id = p_header_rec.sold_to_org_id
709: /* added the following condition to fix the bug 2002486
710: and ship_to_flag = 'Y')*/
711:

Line 806: HZ_CUST_ACCT_RELATE_ALL R WHERE

802: AND ACCT_SITE.CUST_ACCOUNT_ID in (
803: SELECT p_header_rec.sold_to_org_id FROM DUAL
804: UNION
805: SELECT CUST_ACCOUNT_ID FROM
806: HZ_CUST_ACCT_RELATE_ALL R WHERE
807: R.ORG_ID = ACCT_SITE.ORG_ID
808: AND R.RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
809: and R.ship_to_flag = 'Y')
810: AND ROWNUM = 1;

Line 882: HZ_CUST_ACCT_RELATE where

878: customer_id in (
879: Select p_header_rec.sold_to_org_id from dual
880: union
881: select cust_account_id from
882: HZ_CUST_ACCT_RELATE where
883: related_cust_account_id = p_header_rec.sold_to_org_id
884: /* added the following condition to fix the bug 2002486
885: and bill_to_flag = 'Y')
886: