VIEW: APPS.MTL_STAT_ATTRIB_VALUES_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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