SELECT BD.SOURCING_RULE_NAME , BD.DESCRIPTION , LO.MEANING , BD.SOURCING_RULE_ID , BD.LAST_UPDATE_DATE , BD.LAST_UPDATED_BY , BD.CREATION_DATE , BD.CREATED_BY FROM MFG_LOOKUPS LO ,MRP_SOURCING_RULES BD WHERE BD.SOURCING_RULE_TYPE = 2 AND BD.PLANNING_ACTIVE = LO.LOOKUP_CODE AND LO.LOOKUP_TYPE = 'SYS_YES_NO' WITH READ ONLY
SELECT BD.SOURCING_RULE_NAME
, BD.DESCRIPTION
, LO.MEANING
, BD.SOURCING_RULE_ID
, BD.LAST_UPDATE_DATE
, BD.LAST_UPDATED_BY
, BD.CREATION_DATE
, BD.CREATED_BY
FROM MFG_LOOKUPS LO
, MRP_SOURCING_RULES BD
WHERE BD.SOURCING_RULE_TYPE = 2
AND BD.PLANNING_ACTIVE = LO.LOOKUP_CODE
AND LO.LOOKUP_TYPE = 'SYS_YES_NO' WITH READ ONLY
|
|
|