View: BOM_BILL_OF_MATERIALS_V

Product:	BOM - Bills of Material
Description:	Bills of material
Implementation/DBA Data:	APPS.BOM_BILL_OF_MATERIALS_V

View Text

SELECT BOM.ROWID ROW_ID
, BOM.ASSEMBLY_ITEM_ID
, MSI.PRIMARY_UOM_CODE UOM
, MSI.PICK_COMPONENTS_FLAG
, MSI.REPLENISH_TO_ORDER_FLAG
, MSI.BOM_ITEM_TYPE
, MSI.BASE_ITEM_ID
, MSITL.DESCRIPTION
, MSI.ITEM_CATALOG_GROUP_ID
, MSI.ATP_COMPONENTS_FLAG
, MSI.WIP_SUPPLY_TYPE
, MSI.ENG_ITEM_FLAG
, BOM.ORGANIZATION_ID
, BOM.ALTERNATE_BOM_DESIGNATOR
, BOM.LAST_UPDATE_DATE
, BOM.LAST_UPDATED_BY
, BOM.CREATION_DATE
, BOM.CREATED_BY
, BOM.LAST_UPDATE_LOGIN
, BOM.COMMON_ASSEMBLY_ITEM_ID
, BOM.SPECIFIC_ASSEMBLY_COMMENT
, BOM.PENDING_FROM_ECN
, BOM.ATTRIBUTE_CATEGORY
, BOM.ATTRIBUTE1
, BOM.ATTRIBUTE2
, BOM.ATTRIBUTE3
, BOM.ATTRIBUTE4
, BOM.ATTRIBUTE5
, BOM.ATTRIBUTE6
, BOM.ATTRIBUTE7
, BOM.ATTRIBUTE8
, BOM.ATTRIBUTE9
, BOM.ATTRIBUTE10
, BOM.ATTRIBUTE11
, BOM.ATTRIBUTE12
, BOM.ATTRIBUTE13
, BOM.ATTRIBUTE14
, BOM.ATTRIBUTE15
, BOM.ASSEMBLY_TYPE
, BOM.COMMON_BILL_SEQUENCE_ID
, BOM.BILL_SEQUENCE_ID
, BOM.REQUEST_ID
, BOM.PROGRAM_APPLICATION_ID
, BOM.PROGRAM_ID
, BOM.PROGRAM_UPDATE_DATE
, BOM.COMMON_ORGANIZATION_ID
, BOM.NEXT_EXPLODE_DATE
, FCL.MEANING ITEM_TYPE
, MSI.BOM_ENABLED_FLAG
, MSI.EAM_ITEM_TYPE EAM_ITEM_TYPE
, MGL.MEANING EAM_ITEM_TYPE_VALUE
, BOM.STRUCTURE_TYPE_ID
, BOM.IMPLEMENTATION_DATE
, NVL(BST.ENABLE_UNIMPLEMENTED_BOMS
, 'N')
, BOM.EFFECTIVITY_CONTROL
, BOM.SOURCE_BILL_SEQUENCE_ID
FROM FND_COMMON_LOOKUPS FCL
, MTL_SYSTEM_ITEMS MSI
, MTL_SYSTEM_ITEMS_TL MSITL
, BOM_BILL_OF_MATERIALS BOM
, MFG_LOOKUPS MGL
, BOM_STRUCTURE_TYPES_B BST
WHERE MSI.INVENTORY_ITEM_ID = MSITL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MSITL.ORGANIZATION_ID
AND MSITL.LANGUAGE = USERENV('LANG')
AND BOM.ASSEMBLY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND BOM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.ITEM_TYPE = FCL.LOOKUP_CODE(+)
AND FCL.LOOKUP_TYPE(+) = 'ITEM_TYPE'
AND FCL.APPLICATION_ID(+) = 401
AND MGL.LOOKUP_TYPE(+) = 'MTL_EAM_ITEM_TYPE'
AND MGL.LOOKUP_CODE(+) = MSI.EAM_ITEM_TYPE
AND BOM.STRUCTURE_TYPE_ID = BST.STRUCTURE_TYPE_ID (+)

Columns