[Home] [Help]
View: BOM_BILL_OF_MTLS_QF_V
Product: | BOM - Bills of Material |
Description: | View for bill of materials list of values |
Implementation/DBA Data: |
APPS.BOM_BILL_OF_MTLS_QF_V
|
View Text
SELECT BOM.ORGANIZATION_ID
, BOM.ALTERNATE_BOM_DESIGNATOR
, BOM.ASSEMBLY_TYPE
, BOM.ASSEMBLY_ITEM_ID
, BOM.BILL_SEQUENCE_ID
, MIF.CONCATENATED_SEGMENTS
, MIF.BOM_ENABLED_FLAG
, MIF.BOM_ITEM_TYPE
FROM MTL_SYSTEM_ITEMS_KFV MIF
, BOM_BILL_OF_MATERIALS BOM
WHERE BOM.ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND BOM.ASSEMBLY_ITEM_ID = MIF.INVENTORY_ITEM_ID
Columns
Name |
ORGANIZATION_ID |
ALTERNATE_BOM_DESIGNATOR |
ASSEMBLY_TYPE |
ASSEMBLY_ITEM_ID |
BILL_SEQUENCE_ID |
ITEM_NUMBER |
BOM_ENABLED_FLAG |
BOM_ITEM_TYPE |