APPS.OE_BULK_PROCESS_HEADER dependencies on HZ_CUST_ACCT_RELATE

Line 25: FROM hz_cust_acct_relate

21: BEGIN
22:
23: SELECT 'VALID'
24: INTO l_dummy
25: FROM hz_cust_acct_relate
26: WHERE RELATED_CUST_ACCOUNT_ID = p_related_customer_id
27: AND CUST_ACCOUNT_ID = p_customer_id AND STATUS='A'
28: AND ROWNUM = 1;
29:

Line 1423: FROM HZ_CUST_ACCT_RELATE

1419: ELSIF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y' THEN
1420:
1421: SELECT 'VALID'
1422: INTO l_dummy
1423: FROM HZ_CUST_ACCT_RELATE
1424: WHERE RELATED_CUST_ACCOUNT_ID = p_sold_to
1425: AND CUST_ACCOUNT_ID = OE_Bulk_Cache.G_SHIP_TO_TBL(l_c_index).customer_id
1426: AND ship_to_flag = 'Y' AND STATUS='A';
1427:

Line 1514: FROM HZ_CUST_ACCT_RELATE

1510: ELSIF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y' THEN
1511:
1512: SELECT 'VALID'
1513: INTO l_dummy
1514: FROM HZ_CUST_ACCT_RELATE
1515: WHERE RELATED_CUST_ACCOUNT_ID = p_sold_to
1516: AND CUST_ACCOUNT_ID = OE_Bulk_Cache.G_INVOICE_TO_TBL(l_c_index).customer_id
1517: AND bill_to_flag = 'Y' AND STATUS='A';
1518:

Line 1552: FROM HZ_CUST_ACCT_RELATE hcar

1548: AND status = 'A'
1549: AND exists
1550: (
1551: SELECT 1
1552: FROM HZ_CUST_ACCT_RELATE hcar
1553: WHERE hcar.CUST_ACCOUNT_ID = odto.customer_id
1554: AND hcar.RELATED_CUST_ACCOUNT_ID = p_sold_to
1555: AND hcar.ship_to_flag = 'Y'
1556: AND hcar.STATUS ='A'

Line 1582: FROM HZ_CUST_ACCT_RELATE

1578: AND customer_id IN (
1579: Select p_sold_to from dual
1580: union
1581: SELECT CUST_ACCOUNT_ID
1582: FROM HZ_CUST_ACCT_RELATE
1583: WHERE RELATED_CUST_ACCOUNT_ID = p_sold_to
1584: AND ship_to_flag = 'Y' AND STATUS ='A'
1585: );*/
1586: --bug 4729536