[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 |
APPS.MSC_SCH_RULE_CRITERIA_V