Product: | INV - Inventory |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.MTL_STAT_ATTRIB_VALUES_ALL_V |
SELECT B.ROWID ROW_ID
, B.INVENTORY_ITEM_STATUS_CODE
, MFG1.MEANING CONTROL_LEVEL_DISP
, MFG1.LOOKUP_CODE STATUS_CODE_NDB
, C.USER_ATTRIBUTE_NAME_GUI ATTRIBUTE_NAME_DISP
, B.ATTRIBUTE_NAME ATTRIBUTE_NAME
, B.ATTRIBUTE_VALUE ATTRIBUTE_VALUE
, B.ATTRIBUTE_VALUE OLD_ATTRIBUTE_VALUE
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, B.PROGRAM_ID PROGRAM_ID
, B.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, B.REQUEST_ID REQUEST_ID
FROM MTL_STATUS_ATTRIBUTE_VALUES B
, MTL_ITEM_ATTRIBUTES C
, MFG_LOOKUPS MFG1
WHERE B.ATTRIBUTE_NAME = C.ATTRIBUTE_NAME
AND MFG1.LOOKUP_TYPE = 'ITEM_STATUS_CONTROL'
AND MFG1.LOOKUP_CODE = C.STATUS_CONTROL_CODE