APPS.OE_CNCL_VALIDATE_LINE dependencies on HZ_CUST_ACCT_SITES

Line 979: HZ_CUST_ACCT_SITES ACCT_SITE

975:
976: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
977: Into l_dummy
978: FROM HZ_CUST_SITE_USES_ALL SITE,
979: HZ_CUST_ACCT_SITES ACCT_SITE
980: WHERE SITE.SITE_USE_ID = p_deliver_to_org_id
981: AND SITE.SITE_USE_CODE ='DELIVER_TO'
982: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
983: AND ACCT_SITE.CUST_ACCOUNT_ID in (

Line 1190: HZ_CUST_ACCT_SITES_ALL acct_site,

1186: acct_site.party_site_id,
1187: site_use.org_id
1188: FROM
1189: HZ_CUST_SITE_USES_ALL site_use,
1190: HZ_CUST_ACCT_SITES_ALL acct_site,
1191: HZ_CUST_ACCOUNTS_ALL cust_Acct
1192: WHERE site_use.site_use_id = p_site_org_id
1193: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
1194: and acct_site.cust_account_id = cust_acct.cust_account_id;

Line 1991: , HZ_CUST_ACCT_SITES ACCT_SITE

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
1995: AND ACCT_SITE.CUST_ACCT_SITE_ID = SHIP.CUST_ACCT_SITE_ID

Line 2052: , HZ_CUST_ACCT_SITES ACCT_SITE

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
2056: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 2171: , HZ_CUST_ACCT_SITES ACCT_SITE

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
2175: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'