Product: | ENG - Engineering |
---|---|
Description: | Engineering change order types - all records |
Implementation/DBA Data: | APPS.ENG_CHANGE_ORDER_TYPES_VL |
SELECT ECOT.ROWID ROW_ID
, ECOT.CHANGE_ORDER_TYPE_ID
, ECOTL.TYPE_NAME CHANGE_ORDER_TYPE
, ECOT.LAST_UPDATE_DATE
, ECOT.LAST_UPDATED_BY
, ECOT.CREATION_DATE
, ECOT.CREATED_BY
, ECOT.LAST_UPDATE_LOGIN
, ECOT.CHANGE_ORDER_ORGANIZATION_ID
, ECOTL.DESCRIPTION
, ECOT.ASSEMBLY_TYPE
, SUBSTR(ML.MEANING
, 1
, 20) ASSEMBLY_TYPE_DESCRIPTION
, ECOT.DISABLE_DATE
, ECOT.ATTRIBUTE_CATEGORY
, ECOT.ATTRIBUTE1
, ECOT.ATTRIBUTE2
, ECOT.ATTRIBUTE3
, ECOT.ATTRIBUTE4
, ECOT.ATTRIBUTE5
, ECOT.ATTRIBUTE6
, ECOT.ATTRIBUTE7
, ECOT.ATTRIBUTE8
, ECOT.ATTRIBUTE9
, ECOT.ATTRIBUTE10
, ECOT.ATTRIBUTE11
, ECOT.ATTRIBUTE12
, ECOT.ATTRIBUTE13
, ECOT.ATTRIBUTE14
, ECOT.ATTRIBUTE15
, ECOT.REQUEST_ID
, ECOT.PROGRAM_APPLICATION_ID
, ECOT.PROGRAM_ID
, ECOT.PROGRAM_UPDATE_DATE
, ECOT.CHANGE_MGMT_TYPE_CODE
, ECOT.SUBJECT_ID
, ECOT.AUTO_NUMBERING_METHOD
, ECOT.DEFAULT_ASSIGNEE_TYPE
, ECOT.TYPE_CLASSIFICATION
, ECOT.CLASS_CODE_DERIVED_FLAG
, ECOT.SEQUENCE_NUMBER
, ECOT.BASE_CHANGE_MGMT_TYPE_CODE
, ECOT.SEEDED_FLAG
, ECOT.ENABLE_ITEM_IN_LOCAL_ORG
, ECOT.CREATE_BOM_IN_LOCAL_ORG
, ECOTL.TAB_TEXT
, ECOTL.TYPE_NAME
, ECOT.START_DATE
, ECOT.DEFAULT_ASSIGNEE_ID
, ECOT.OBJECT_ID
, ECOT.SUBJECT_UPDATABLE_FLAG
, ECOT.XML_DATA_SOURCE_CODE
FROM ENG_CHANGE_ORDER_TYPES ECOT
, MFG_LOOKUPS ML
, ENG_CHANGE_ORDER_TYPES_TL ECOTL
WHERE ML.LOOKUP_CODE(+) = ECOT.ASSEMBLY_TYPE
AND ML.LOOKUP_TYPE (+)= 'ECG_BOM_COMP_SEL'
AND ECOT.CHANGE_ORDER_TYPE_ID = ECOTL.CHANGE_ORDER_TYPE_ID
AND ECOTL.LANGUAGE = USERENV('LANG')
AND (ECOT.TYPE_CLASSIFICATION <> 'CATEGORY' OR ( ECOT.TYPE_CLASSIFICATION= 'CATEGORY'
AND ( NVL(FND_PROFILE.VALUE('RESP_APPL_ID')
, 1) = 1 OR (ECOT.BASE_CHANGE_MGMT_TYPE_CODE = 'DOM_DOCUMENT_LIFECYCLE') OR EXISTS (SELECT CHANGE_TYPE_ID
FROM ENG_CHANGE_TYPE_APPLICATIONS
WHERE CHANGE_TYPE_ID = ECOT.CHANGE_ORDER_TYPE_ID
AND APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') ) ) ) )
AND ((FND_PROFILE.VALUE('RESP_ID') NOT IN (SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY
WHERE RESPONSIBILITY_KEY ='EGO_PIM_DATA_LIBRARIAN')
AND FND_PROFILE.VALUE('EGO_ENABLE_PLM') = 1 ) OR (ECOT.BASE_CHANGE_MGMT_TYPE_CODE NOT IN ('ISSUE'
, 'IDEA') ) )