[Home] [Help]
View: ENGFV_ECO_PRIORITIES
View Text
SELECT PR.ENG_CHANGE_PRIORITY_CODE PRIORITY_CODE
, PA.ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, PR.DESCRIPTION
, PR.DISABLE_DATE INACTIVE_DATE
, PR.PRIORITY_LEVEL PRIORITY_SEQUENCE_NUMBER
, '_DF:ENG:ENG_CHANGE_PRIORITIES:PR'
, PR.ORGANIZATION_ID
, PR.CREATION_DATE CREATED_ON
, PR.CREATED_BY CREATED_BY
, PR.LAST_UPDATE_DATE UPDATED_ON
, PR.LAST_UPDATED_BY UPDATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, ENG_CHANGE_PRIORITIES PR
WHERE PR.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND PR.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:PR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
PRIORITY_CODE |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
DESCRIPTION |
INACTIVE_DATE |
PRIORITY_SEQUENCE_NUMBER |
"_DF" |
ORGANIZATION_ID |
UPDATED_ON |
UPDATED_BY |
CREATED_ON |
CREATED_BY |