INV_ZONES_VL

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name
ROW_ID ZONE_ID ORGANIZATION_ID STATUS START_DATE END_DATE DEFAULT_ZONE_FLAG DEFAULT_DELIVERY_CART_ID DEPARTMENT_ID ENABLE_WORKFORCE_SCHEDULING OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ZONE_NAME DESCRIPTION LANGUAGE

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.ZONE_ID, B.ORGANIZATION_ID, B.STATUS, B.START_DATE, B.END_DATE, B.DEFAULT_ZONE_FLAG, B.DEFAULT_DELIVERY_CART_ID, B.DEPARTMENT_ID, B.ENABLE_WORKFORCE_SCHEDULING, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.ZONE_NAME, T.DESCRIPTION, T.LANGUAGE FROM INV_ZONES B, INV_ZONES_TL T WHERE B.ZONE_ID = T.ZONE_ID AND T.LANGUAGE = USERENV('LANG')