DBA Data[Home] [Help]

APPS.FTE_TL_CACHE dependencies on HZ_PARTY_SITES

Line 10209: HZ_PARTY_SITES sites

10205: SELECT ploc.LOCATION_ID internal_org_location_id
10206: FROM PO_LOCATION_ASSOCIATIONS_ALL ploc,
10207: hz_cust_site_uses_all site_uses,
10208: hz_cust_acct_sites_all acct_sites,
10209: HZ_PARTY_SITES sites
10210: WHERE ploc.SITE_USE_ID = site_uses.SITE_USE_ID
10211: AND site_uses.CUST_ACCT_SITE_ID = acct_sites.CUST_ACCT_SITE_ID
10212: AND acct_sites.PARTY_SITE_ID = sites.PARTY_SITE_ID
10213: AND ploc.CUSTOMER_ID = acct_sites.CUST_ACCOUNT_ID