EGP_ITEM_STATUS_VL

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name

INVENTORY_ITEM_STATUS_CODE INVENTORY_ITEM_STATUS_ID INVENTORY_ITEM_STATUS_NAME DESCRIPTION DISABLE_DATE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID PROGRAM_NAME PROGRAM_APP_NAME OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT INVENTORY_ITEM_STATUS_CODE ,INVENTORY_ITEM_STATUS_ID, INVENTORY_ITEM_STATUS_NAME ,DESCRIPTION ,DISABLE_DATE ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,CREATION_DATE ,CREATED_BY ,LAST_UPDATE_LOGIN ,ATTRIBUTE_CATEGORY ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,ATTRIBUTE11 ,ATTRIBUTE12 ,ATTRIBUTE13 ,ATTRIBUTE14 ,ATTRIBUTE15 ,REQUEST_ID ,PROGRAM_NAME , PROGRAM_APP_NAME,OBJECT_VERSION_NUMBER FROM EGP_ITEM_STATUS_TL WHERE LANGUAGE = USERENV ('LANG')