SELECT BD.SOURCING_RULE_NAME , BD.DESCRIPTION , LO.MEANING , '_DF:MRP:MRP_SOURCING_RULES:bd' , 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 LO.LOOKUP_CODE = BD.PLANNING_ACTIVE AND LO.LOOKUP_TYPE = 'SYS_YES_NO' WITH READ ONLY
SELECT BD.SOURCING_RULE_NAME
, BD.DESCRIPTION
, LO.MEANING
, '_DF:MRP:MRP_SOURCING_RULES:BD'
, 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 LO.LOOKUP_CODE = BD.PLANNING_ACTIVE
AND LO.LOOKUP_TYPE = 'SYS_YES_NO' WITH READ ONLY
|
|
|