View: MRP_SCH_RULE_CRITERIA_V

Product:	MRP - Master Scheduling/MRP
Description:	This view is based on MRP_SCHEDULING_RULES. It is the base table view for the RULE_CRITERIA block on the MRPSCHRS form.
Implementation/DBA Data:	APPS.MRP_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
, MRP_SCHEDULING_RULES MSR
WHERE MFG.LOOKUP_CODE = MSR.USAGE_CODE
AND MFG.LOOKUP_TYPE = 'MRP_SCHEDULING_RULES'

Columns