eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ENGFV_ECO_WORKFLOW_RULES

Source

View Text - Preformatted


SELECT TY.CHANGE_ORDER_TYPE CHANGE_TYPE_CODE , RU.ENG_CHANGE_PRIORITY_CODE PRIORITY_CODE , PA.ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , RU.PROCESS_NAME WORKFLOW_PROCESS_NAME , RU.CHANGE_ORDER_TYPE_ID , RU.ORGANIZATION_ID , RU.LAST_UPDATE_DATE , RU.LAST_UPDATED_BY , RU.CREATION_DATE , RU.CREATED_BY FROM MTL_PARAMETERS PA , ENG_CHANGE_ORDER_TYPES TY , HR_ALL_ORGANIZATION_UNITS AL , ENG_CHANGE_TYPE_PROCESSES RU WHERE RU.CHANGE_ORDER_TYPE_ID = TY.CHANGE_ORDER_TYPE_ID AND RU.ORGANIZATION_ID = PA.ORGANIZATION_ID AND RU.ORGANIZATION_ID = AL.ORGANIZATION_ID AND '_SEC:RU.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT TY.CHANGE_ORDER_TYPE CHANGE_TYPE_CODE
, RU.ENG_CHANGE_PRIORITY_CODE PRIORITY_CODE
, PA.ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, RU.PROCESS_NAME WORKFLOW_PROCESS_NAME
, RU.CHANGE_ORDER_TYPE_ID
, RU.ORGANIZATION_ID
, RU.LAST_UPDATE_DATE
, RU.LAST_UPDATED_BY
, RU.CREATION_DATE
, RU.CREATED_BY
FROM MTL_PARAMETERS PA
, ENG_CHANGE_ORDER_TYPES TY
, HR_ALL_ORGANIZATION_UNITS AL
, ENG_CHANGE_TYPE_PROCESSES RU
WHERE RU.CHANGE_ORDER_TYPE_ID = TY.CHANGE_ORDER_TYPE_ID
AND RU.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RU.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:RU.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY