APPS.OE_CNCL_VALIDATE_LINE dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1990: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

1986: oe_debug_pub.add('ship_to_contact_id :'||to_char(p_line_rec.ship_to_contact_id),2);
1987:
1988: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1989: INTO l_dummy
1990: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1991: , HZ_CUST_ACCT_SITES ACCT_SITE
1992: , HZ_CUST_SITE_USES_ALL SHIP
1993: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.ship_to_contact_id
1994: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID

Line 2051: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

2047: oe_debug_pub.add('deliver_to_contact_id :'||to_char(p_line_rec.deliver_to_contact_id),2);
2048:
2049: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2050: INTO l_dummy
2051: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
2052: , HZ_CUST_ACCT_SITES ACCT_SITE
2053: , HZ_CUST_SITE_USES_ALL DELI
2054: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.deliver_to_contact_id
2055: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID

Line 2170: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

2166: oe_debug_pub.add('invoice_to_contact_id :'||to_char(p_line_rec.invoice_to_contact_id),2);
2167:
2168: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2169: INTO l_dummy
2170: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
2171: , HZ_CUST_ACCT_SITES ACCT_SITE
2172: , HZ_CUST_SITE_USES_ALL INV
2173: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.invoice_to_contact_id
2174: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID