機械翻訳について

HZ_GEOGRAPHY_IDENTIFIERS_VL

詳細

• スキーマ: FUSION

• オブジェクト所有者: HZ

• オブジェクト・タイプ: VIEW

列

名前
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

問合せ

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')))