APPS.OE_CNCL_VALIDATE_LINE dependencies on HZ_CUST_ACCT_RELATE

Line 872: HZ_CUST_ACCT_RELATE hcar

868: AND status = 'A'
869: AND EXISTS
870: (
871: SELECT 1 FROM
872: HZ_CUST_ACCT_RELATE hcar
873: WHERE hcar.cust_account_id = osto.customer_id AND
874: hcar.RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
875: AND hcar.ship_to_flag = 'Y'
876: )

Line 909: HZ_CUST_ACCT_RELATE

905: customer_id in (
906: Select p_sold_to_org_id from dual
907: union
908: select CUST_ACCOUNT_ID from
909: HZ_CUST_ACCT_RELATE
910: where RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
911: /* added the following condition to fix the bug 2002486
912: and ship_to_flag = 'Y')
913:

Line 987: HZ_CUST_ACCT_RELATE_ALL R WHERE

983: AND ACCT_SITE.CUST_ACCOUNT_ID in (
984: SELECT p_sold_to_org_id FROM DUAL
985: UNION
986: SELECT CUST_ACCOUNT_ID FROM
987: HZ_CUST_ACCT_RELATE_ALL R WHERE
988: R.ORG_ID = ACCT_SITE.ORG_ID
989: AND R.RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
990: and R.ship_to_flag = 'Y')
991: AND ROWNUM = 1;

Line 1215: select 1 from HZ_CUST_ACCT_RELATE hcar

1211: WHERE oito.site_use_id = p_line_rec.invoice_to_org_id
1212: AND oito.status = 'A' AND
1213: EXISTS
1214: (
1215: select 1 from HZ_CUST_ACCT_RELATE hcar
1216: where hcar.CUST_ACCOUNT_ID = oito.customer_id
1217: and hcar.RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id
1218: /* added the following condition to fix the bug 2002486 */
1219: and hcar.bill_to_flag = 'Y'

Line 2113: HZ_CUST_ACCT_RELATE

2109: customer_id in (
2110: Select p_line_rec.sold_to_org_id from dual
2111: union
2112: select CUST_ACCOUNT_ID from
2113: HZ_CUST_ACCT_RELATE
2114: where RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id
2115: /* added the following condition to fix the bug 2002486
2116: and bill_to_flag = 'Y')
2117: and rownum = 1;*/

Line 2571: HZ_CUST_ACCT_RELATE

2567: INTO l_dummy
2568: FROM dual
2569: WHERE exists(
2570: select 'x' from
2571: HZ_CUST_ACCT_RELATE
2572: where RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id
2573: AND CUST_ACCOUNT_ID = l_sold_to_org
2574:
2575: );