1. Tables and Views for Sales and Fusion Service
  2. HZ_GEOGRAPHY_IDENTIFIERS_VL

HZ_GEOGRAPHY_IDENTIFIERS_VL

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: VIEW

Columns

Name

GEOGRAPHY_IDENTIFIER_ID

GEOGRAPHY_ID

IMPORT_BATCH_ID

GEO_DATA_PROVIDER

IDENTIFIER_SUBTYPE

IDENTIFIER_VALUE

IDENTIFIER_TYPE

PRIMARY_FLAG

LANGUAGE_CODE

GEOGRAPHY_USE

GEOGRAPHY_TYPE

Query

SQL_Statement

SELECT

GEOGRAPHY_IDENTIFIER_ID,

GEOGRAPHY_ID,

IMPORT_BATCH_ID,

GEO_DATA_PROVIDER,

IDENTIFIER_SUBTYPE,

IDENTIFIER_VALUE,

IDENTIFIER_TYPE,

PRIMARY_FLAG,

LANGUAGE_CODE,

GEOGRAPHY_USE,

GEOGRAPHY_TYPE

FROM

HZ_GEOGRAPHY_IDENTIFIERS o

WHERE

( o.LANGUAGE_CODE = USERENV('LANG'))

OR (o.PRIMARY_FLAG = 'Y' AND NOT EXISTS (SELECT 1 FROM HZ_GEOGRAPHY_IDENTIFIERS i

WHERE i.IDENTIFIER_TYPE = o.IDENTIFIER_TYPE AND i.GEOGRAPHY_ID = o.GEOGRAPHY_ID AND i.LANGUAGE_CODE = USERENV('LANG')))