VIEW: APPS.BOM_BILL_OF_MATERIALS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)