ATK_KR_TERRITORIES_VL

Details

• Schema: FUSION

• Object owner: ATK

• Object type: VIEW

Columns

Name
ROW_ID ENTERPRISE_ID TERRITORY_CODE TERRITORY_SHORT_NAME DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT ROWID row_id, ENTERPRISE_ID, TERRITORY_CODE, TERRITORY_SHORT_NAME, DESCRIPTION, 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' and LANGUAGE = USERENV('LANG') UNION SELECT b.ROWID row_id, t.ENTERPRISE_ID, b.TERRITORY_CODE, t.TERRITORY_SHORT_NAME, t.DESCRIPTION, 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 t.LANGUAGE = USERENV('LANG')