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 1191: HZ_CUST_ACCT_SITES_ALL acct_site,

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

Line 1992: , HZ_CUST_ACCT_SITES ACCT_SITE

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

Line 2053: , HZ_CUST_ACCT_SITES ACCT_SITE

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

Line 2172: , HZ_CUST_ACCT_SITES ACCT_SITE

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