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