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 1214: select 1 from HZ_CUST_ACCT_RELATE hcar

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

Line 2112: HZ_CUST_ACCT_RELATE

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

Line 2551: HZ_CUST_ACCT_RELATE

2547: INTO l_dummy
2548: FROM dual
2549: WHERE exists(
2550: select 'x' from
2551: HZ_CUST_ACCT_RELATE
2552: where RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id
2553: AND CUST_ACCOUNT_ID = l_sold_to_org
2554:
2555: );