VIEW: APPS.ENG_CHANGE_TYPE_PROCESSES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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