[Home] [Help]
View: MSC_SCH_RULE_CRITERIA_V
View Text
SELECT DISTINCT MSR.ROWID
, MSR.RULE_ID
, MSR.USAGE_CODE
, MFG.MEANING
, MSR.SEQUENCE_NUMBER
, MSR.CREATED_BY
, MSR.CREATION_DATE
, MSR.LAST_UPDATED_BY
, MSR.LAST_UPDATE_DATE
, MSR.LAST_UPDATE_LOGIN
FROM MFG_LOOKUPS MFG
, MSC_SCHEDULING_RULES MSR
WHERE MFG.LOOKUP_CODE = MSR.USAGE_CODE
AND MFG.LOOKUP_TYPE = 'MSC_PRIORITY_RULE'
Columns
Name |
ROW_ID |
RULE_ID |
CRITERIA_ID |
CRITERIA_NAME |
SEQUENCE_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |