View: ENGBV_ECO_REVISIONS

Product:	ENG - Engineering
Description:	- Retrofitted
Implementation/DBA Data:	APPS.ENGBV_ECO_REVISIONS

View Text

SELECT RE.CHANGE_NOTICE ECO_NAME
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGNIZATION_NAME
, RE.REVISION
, RE.COMMENTS
, RE.REVISION_ID
, RE.ORGANIZATION_ID
, RE.LAST_UPDATE_DATE UPDATED_ON
, RE.LAST_UPDATED_BY UPDATED_BY
, RE.CREATION_DATE CREATED_ON
, RE.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, ENG_CHANGE_ORDER_REVISIONS RE
WHERE RE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns