Product: | ENG - Engineering |
---|---|
Description: | Engineering change type processes |
Implementation/DBA Data: | APPS.ENG_CHANGE_TYPE_PROCESSES_V |
SELECT ECTP.ROWID ROW_ID
, ECTP.CHANGE_ORDER_TYPE_ID
, ECTP.ENG_CHANGE_PRIORITY_CODE
, ECP.DESCRIPTION PRIORITY_DESCRIPTION
, ECTP.ORGANIZATION_ID
, ECTP.PROCESS_NAME
, ECTP.LAST_UPDATE_DATE
, ECTP.LAST_UPDATED_BY
, ECTP.CREATION_DATE
, ECTP.CREATED_BY
, ECTP.LAST_UPDATE_LOGIN
, ECTP.ATTRIBUTE_CATEGORY
, ECTP.ATTRIBUTE1
, ECTP.ATTRIBUTE2
, ECTP.ATTRIBUTE3
, ECTP.ATTRIBUTE4
, ECTP.ATTRIBUTE5
, ECTP.ATTRIBUTE6
, ECTP.ATTRIBUTE7
, ECTP.ATTRIBUTE8
, ECTP.ATTRIBUTE9
, ECTP.ATTRIBUTE10
, ECTP.ATTRIBUTE11
, ECTP.ATTRIBUTE12
, ECTP.ATTRIBUTE13
, ECTP.ATTRIBUTE14
, ECTP.ATTRIBUTE15
, ECTP.REQUEST_ID
, ECTP.PROGRAM_APPLICATION_ID
, ECTP.PROGRAM_ID
, ECTP.PROGRAM_UPDATE_DATE
FROM ENG_CHANGE_PRIORITIES ECP
, ENG_CHANGE_TYPE_PROCESSES ECTP
WHERE ECTP.ORGANIZATION_ID = -1
AND ECTP.ENG_CHANGE_PRIORITY_CODE = ECP.ENG_CHANGE_PRIORITY_CODE(+)
AND ECP.ORGANIZATION_ID(+) = -1