View: ENGBV_ENGINEERING_CHNG_ORDERS

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

View Text

SELECT EN.CHANGE_NOTICE ECO_NAME
, AL.NAME ORGANIZATION_NAME
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, EN.DESCRIPTION
, EN.INITIATION_DATE ECO_CREATION_DATE
, EN.IMPLEMENTATION_DATE
, EN.CANCELLATION_DATE
, EN.CANCELLATION_COMMENTS
, EN.PRIORITY_CODE
, EN.REASON_CODE
, EN.ESTIMATED_ENG_COST ENG_IMPLEMENTATION_COSTS
, EN.ESTIMATED_MFG_COST MFG_IMPLEMENTAION_COSTS
, '_LA:EN.APPROVAL_STATUS_TYPE:MFG_LOOKUPS:ENG_ECN_APPROVAL_STATUS:MEANING'
, '_LA:EN.STATUS_TYPE:MFG_LOOKUPS:ECG_ECN_STATUS:MEANING'
, EN.APPROVAL_DATE
, EN.APPROVAL_REQUEST_DATE
, EN.ORGANIZATION_ID
, EN.REQUESTOR_ID
, EN.APPROVAL_LIST_ID
, EN.CHANGE_ORDER_TYPE_ID
, EN.RESPONSIBLE_ORGANIZATION_ID
, EN.PROJECT_ID
, EN.TASK_ID
, EN.CREATION_DATE CREATED_ON
, EN.CREATED_BY CREATED_BY
, EN.LAST_UPDATE_DATE UPDATED_ON
, EN.LAST_UPDATED_BY UPDATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, ENG_ENGINEERING_CHANGES EN
WHERE EN.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND EN.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND '_SEC:EN.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns