VIEW: APPS.MRP_SCH_RULE_CRITERIA_V

Source

View Text - Preformatted

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, MRP_SCHEDULING_RULES MSR WHERE MFG.LOOKUP_CODE = MSR.USAGE_CODE AND MFG.LOOKUP_TYPE = 'MRP_SCHEDULING_RULES'

View Text - HTML Formatted

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
, MRP_SCHEDULING_RULES MSR
WHERE MFG.LOOKUP_CODE = MSR.USAGE_CODE
AND MFG.LOOKUP_TYPE = 'MRP_SCHEDULING_RULES'