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 1429: FROM HZ_CUST_ACCT_RELATE

1425: ELSIF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y' THEN
1426:
1427: SELECT 'VALID'
1428: INTO l_dummy
1429: FROM HZ_CUST_ACCT_RELATE
1430: WHERE RELATED_CUST_ACCOUNT_ID = p_sold_to
1431: AND CUST_ACCOUNT_ID = OE_Bulk_Cache.G_SHIP_TO_TBL(l_c_index).customer_id
1432: AND ship_to_flag = 'Y' AND STATUS='A';
1433:

Line 1520: FROM HZ_CUST_ACCT_RELATE

1516: ELSIF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y' THEN
1517:
1518: SELECT 'VALID'
1519: INTO l_dummy
1520: FROM HZ_CUST_ACCT_RELATE
1521: WHERE RELATED_CUST_ACCOUNT_ID = p_sold_to
1522: AND CUST_ACCOUNT_ID = OE_Bulk_Cache.G_INVOICE_TO_TBL(l_c_index).customer_id
1523: AND bill_to_flag = 'Y' AND STATUS='A';
1524:

Line 1558: FROM HZ_CUST_ACCT_RELATE hcar

1554: AND status = 'A'
1555: AND exists
1556: (
1557: SELECT 1
1558: FROM HZ_CUST_ACCT_RELATE hcar
1559: WHERE hcar.CUST_ACCOUNT_ID = odto.customer_id
1560: AND hcar.RELATED_CUST_ACCOUNT_ID = p_sold_to
1561: AND hcar.ship_to_flag = 'Y'
1562: AND hcar.STATUS ='A'

Line 1588: FROM HZ_CUST_ACCT_RELATE

1584: AND customer_id IN (
1585: Select p_sold_to from dual
1586: union
1587: SELECT CUST_ACCOUNT_ID
1588: FROM HZ_CUST_ACCT_RELATE
1589: WHERE RELATED_CUST_ACCOUNT_ID = p_sold_to
1590: AND ship_to_flag = 'Y' AND STATUS ='A'
1591: );*/
1592: --bug 4729536