[Home] [Help]
View: BOM_PRODUCTFAMILY_MEM_V
Product: | BOM - Bills of Material |
Description: | View on BOM_INVENTORY_COMPONENTS and MTL_SYSTEMS_ITEMS, used by the product family functionality in R11 |
Implementation/DBA Data: |
APPS.BOM_PRODUCTFAMILY_MEM_V
|
View Text
SELECT DISTINCT BOM.ORGANIZATION_ID
, BIC.COMPONENT_ITEM_ID
, BIC.BILL_SEQUENCE_ID
, ML1.MEANING FORECAST_CONTROL
, ML2.MEANING PLANNING_METHOD
, ML3.MEANING BOM_ITEM_TYPE
FROM MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MTL_SYSTEM_ITEMS MSI
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BOM
WHERE BIC.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID
AND BIC.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND BOM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND ML1.LOOKUP_CODE (+) = MSI.ATO_FORECAST_CONTROL
AND ML1.LOOKUP_TYPE (+) = 'MRP_ATO_FORECAST_CONTROL'
AND ML2.LOOKUP_CODE (+) = MSI.MRP_PLANNING_CODE
AND ML2.LOOKUP_TYPE (+) = 'MRP_PLANNING_CODE'
AND ML3.LOOKUP_CODE = BIC.BOM_ITEM_TYPE
AND ML3.LOOKUP_TYPE = 'BOM_ITEM_TYPE'
Columns
Name |
ORGANIZATION_ID |
COMPONENT_ITEM_ID |
BILL_SEQUENCE_ID |
FORECAST_CONTROL |
PLANNING_METHOD |
BOM_ITEM_TYPE |