[Home] [Help]
View: ENGBV_ECO_WORKFLOW_RULES
View Text
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.CREATION_DATE CREATED_ON
, RU.CREATED_BY CREATED_BY
, RU.LAST_UPDATE_DATE UPDATED_ON
, RU.LAST_UPDATED_BY UPDATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, ENG_CHANGE_ORDER_TYPES TY
, 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
Columns
| Name |
| CHANGE_TYPE_CODE |
| PRIORITY_CODE |
| ORGANIZATION_CODE |
| ORGANIZATION_NAME |
| WORKFLOW_PROCESS_NAME |
| CHANGE_ORDER_TYPE_ID |
| ORGANIZATION_ID |
| CREATION_ON |
| CREATED_BY |
| UPDATED_ON |
| UPDATED_BY |
APPS.ENGBV_ECO_WORKFLOW_RULES