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