[Home] [Help]
View: MRPFV_BILL_OF_DISTRIBUTIONS
View Text
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
Columns
Name |
BILL_OF_DISTRIBUTION |
DESCRIPTION |
PLANNING_ACTIVE_FLAG |
"_DF" |
BILL_OF_DISTRIBUTION_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |