[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 |
APPS.MRPFV_BILL_OF_DISTRIBUTIONS