ZX_LOC_ASSIGNMENTS_V

Details

• Schema: FUSION

• Object owner: ZX

• Object type: VIEW

Columns

Name
LOCATION_ID SET_ID LOC_ID CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN LAST_UPDATE_DATE LAST_UPDATED_BY REQUEST_ID JOB_DEFINITION_PACKAGE JOB_DEFINITION_NAME OBJECT_VERSION_NUMBER CREATED_BY_MODULE

Query

SQL_Statement

SELECT distinct hzloc.location_id location_id, acct_site.set_id set_id, to_number(null) loc_id, hzloc.CREATED_BY, hzloc.CREATION_DATE, hzloc.LAST_UPDATE_LOGIN, hzloc.LAST_UPDATE_DATE, hzloc.LAST_UPDATED_BY, hzloc.REQUEST_ID, hzloc.JOB_DEFINITION_PACKAGE, hzloc.JOB_DEFINITION_NAME, hzloc.OBJECT_VERSION_NUMBER, hzloc.CREATED_BY_MODULE FROM hz_locations hzloc, hz_cust_acct_sites_all acct_site, hz_party_sites p_site, hz_geo_struct_map map, hz_geo_name_reference_log log WHERE acct_site.party_site_id = p_site.party_site_id AND p_site.location_id = hzloc.location_id AND hzloc.location_id = log.location_id AND log.location_table_name = 'HZ_LOCATIONS' AND log.usage_code = 'TAX' AND log.map_status = 'S' AND hzloc.country = map.country_code AND map.loc_tbl_name = 'HZ_LOCATIONS' UNION SELECT distinct hzloc.location_id location_id, acct_site.set_id set_id, to_number(null) loc_id, hzloc.CREATED_BY, hzloc.CREATION_DATE, hzloc.LAST_UPDATE_LOGIN, hzloc.LAST_UPDATE_DATE, hzloc.LAST_UPDATED_BY, hzloc.REQUEST_ID, hzloc.JOB_DEFINITION_PACKAGE, hzloc.JOB_DEFINITION_NAME, hzloc.OBJECT_VERSION_NUMBER, hzloc.CREATED_BY_MODULE FROM hz_locations hzloc, hz_cust_acct_sites_all acct_site, hz_party_sites p_site, hz_geographies g WHERE acct_site.party_site_id = p_site.party_site_id AND p_site.location_id = hzloc.location_id AND hzloc.country = g.country_code AND g.geography_type = 'COUNTRY' AND NOT EXISTS (SELECT '1' FROM hz_geo_struct_map map WHERE map.country_code = hzloc.country AND map.loc_tbl_name = 'HZ_LOCATIONS')