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

HZ_GEOGRAPHY_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: VIEW

Columns

Name

GEOGRAPHY_TYPE_ID

GEOGRAPHY_TYPE

OBJECT_VERSION_NUMBER

GEOGRAPHY_USE

POSTAL_CODE_RANGE_FLAG

LIMITED_BY_GEOGRAPHY_ID

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

CREATED_BY_MODULE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

GEOGRAPHY_TYPE_NAME

GEO_ZONE_FLAG

Query

SQL_Statement

SELECT

B.GEOGRAPHY_TYPE_ID,

B.GEOGRAPHY_TYPE,

B.OBJECT_VERSION_NUMBER,

B.GEOGRAPHY_USE,

B.POSTAL_CODE_RANGE_FLAG,

B.LIMITED_BY_GEOGRAPHY_ID,

B.LAST_UPDATED_BY,

B.CREATION_DATE,

B.CREATED_BY,

B.CREATED_BY_MODULE,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.REQUEST_ID,

B.JOB_DEFINITION_NAME,

B.JOB_DEFINITION_PACKAGE,

T.GEOGRAPHY_TYPE_NAME,

NVL((SELECT 'Y'

FROM FND_LOOKUPS

WHERE LOOKUP_TYPE='ORA_HZ_GEO_USAGE'

AND LOOKUP_CODE=B.GEOGRAPHY_USE

AND LOOKUP_CODE NOT IN ('TM','MASTER_REF')

AND ENABLED_FLAG='Y'),'N') GEO_ZONE_FLAG

FROM

HZ_GEOGRAPHY_TYPES_TL T,

HZ_GEOGRAPHY_TYPES_B B

WHERE

B.GEOGRAPHY_TYPE = T.GEOGRAPHY_TYPE AND T.LANGUAGE = USERENV('LANG')