Product: | ENG - Engineering |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ENG_CHANGE_MGMT_TYPES_VL |
SELECT ECMT.CHANGE_MGMT_TYPE_CODE
, ECMT.SEQUENCE_NUMBER
, ECMT.CREATED_BY
, ECMT.CREATION_DATE
, ECMT.LAST_UPDATED_BY
, ECMT.LAST_UPDATE_DATE
, ECMT.LAST_UPDATE_LOGIN
, DECODE(ECMT.DISABLE_DATE
, NULL
, 'N'
, DECODE( SIGN(ECMT.DISABLE_DATE - SYSDATE)
, 1
, 'N'
, 'Y')) DISABLE_FLAG
, ECMT.CHANGE_ORDER_TYPE
, ECMT.DESCRIPTION
, ECMT.TAB_TEXT
, ECMT.BASE_CHANGE_MGMT_TYPE_CODE
, ECMT.XML_DATA_SOURCE_CODE
FROM ENG_CHANGE_ORDER_TYPES_V ECMT
WHERE ECMT.TYPE_CLASSIFICATION= 'CATEGORY'