APPS.OE_CNCL_VALIDATE_LINE dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1991: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

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

Line 2052: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

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

Line 2171: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

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