View: MRPBV_SOURCING_RULES

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPBV_SOURCING_RULES

View Text

SELECT SO.SOURCING_RULE_NAME
, SO.DESCRIPTION
, LO.MEANING
, SO.SOURCING_RULE_ID
, SO.ORGANIZATION_ID
, SO.LAST_UPDATE_DATE
, SO.LAST_UPDATED_BY
, SO.CREATION_DATE
, SO.CREATED_BY
FROM MFG_LOOKUPS LO
, MRP_SOURCING_RULES SO
WHERE SO.SOURCING_RULE_TYPE = 1
AND SO.PLANNING_ACTIVE = LO.LOOKUP_CODE
AND LO.LOOKUP_TYPE = 'SYS_YES_NO'
AND '_SEC:SO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns