VIEW: APPS.ENGBV_ENGINEERING_CHNG_ORDERS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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