INV_MATERIAL_STATUSES_VL
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: VIEW
Columns
Name |
---|
ROW_ID OBJECT_VERSION_NUMBER ATTRIBUTE15 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 LOCATOR_CONTROL LOT_CONTROL SERIAL_CONTROL STATUS_ID ZONE_CONTROL ATTRIBUTE1 ATTRIBUTE14 CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE ATTRIBUTE_CATEGORY ENABLED_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE STATUS_CODE DESCRIPTION LPN_CONTROL INVENTORY_ATP_CODE AVAILABILITY_TYPE RESERVABLE_TYPE |
Query
SQL_Statement |
---|
SELECT B.ROWID ROW_ID, B.OBJECT_VERSION_NUMBER,B.ATTRIBUTE15, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.LOCATOR_CONTROL, B.LOT_CONTROL, B.SERIAL_CONTROL, B.STATUS_ID, B.ZONE_CONTROL, B.ATTRIBUTE1, B.ATTRIBUTE14, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.REQUEST_ID, B.JOB_DEFINITION_NAME, B.JOB_DEFINITION_PACKAGE, B.ATTRIBUTE_CATEGORY, B.ENABLED_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, T.STATUS_CODE, T.DESCRIPTION, B.LPN_CONTROL, B.INVENTORY_ATP_CODE, B.AVAILABILITY_TYPE, B.RESERVABLE_TYPE FROM INV_MATERIAL_STATUSES_TL T, INV_MATERIAL_STATUSES_B B WHERE B.STATUS_ID = T.STATUS_ID and T.LANGUAGE = userenv('LANG') |