機械翻訳について

ATK_KRH_TERRITORIES_L_VL

詳細

• スキーマ: FUSION

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

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

列

名前
ROW_ID TERRITORY_CODE TERRITORY_SHORT_NAME DESCRIPTION LANGUAGE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

問合せ

SQL_Statement

SELECT ROWID row_id, TERRITORY_CODE, TERRITORY_SHORT_NAME, DESCRIPTION, LANGUAGE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER FROM ATK_KRH_TERRITORIES_TL where territory_code='00' UNION SELECT b.ROWID row_id, b.TERRITORY_CODE, t.TERRITORY_SHORT_NAME, t.DESCRIPTION, t.LANGUAGE, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER FROM ATK_KRH_TERRITORIES b, FND_TERRITORIES_TL t WHERE b.territory_code = t.territory_code and b.territory_code <> '00'