View: BOM_EXPLOSION_VIEW

Product:	BOM - Bills of Material
Description:	Indented bill of material for report
Implementation/DBA Data:	APPS.BOM_EXPLOSION_VIEW

View Text

SELECT /* ORDERED INDEX(BET BOM_EXPLOSION_TEMP_N3) INDEX(BIC BOM_INVENTORY_COMPONENTS_U2) INDEX(BOM BOM_BILL_OF_MATERIALS_U2) INDEX(MSI MTL_SYSTEM_ITEMS_U1) INDEX(FCL FND_COMMON_LOOKUPS_U1) */ BET.TOP_BILL_SEQUENCE_ID
, BET.BILL_SEQUENCE_ID
, BET.COMPONENT_SEQUENCE_ID
, BET.COMPONENT_ITEM_ID
, BET.ORGANIZATION_ID
, BET.OPERATION_SEQ_NUM
, BET.PLAN_LEVEL
, BET.EXTENDED_QUANTITY
, BET.ITEM_NUM
, BET.SORT_ORDER
, BET.GROUP_ID
, BET.ITEM_COST
, NVL(MSI.RESERVABLE_TYPE
, 2) RESERVABLE_TYPE
, BET.EXTEND_COST_FLAG
, BET.TOP_ALTERNATE_DESIGNATOR
, BET.TOP_ITEM_ID
, BET.EFFECTIVITY_DATE
, BET.DISABLE_DATE
, BET.IMPLEMENTATION_DATE
, BET.OPTIONAL
, BET.PLANNING_FACTOR
, BET.COMPONENT_YIELD_FACTOR
, BET.INCLUDE_IN_ROLLUP_FLAG
, BET.WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, BET.SUPPLY_SUBINVENTORY
, BET.SUPPLY_LOCATOR_ID
, BET.COMPONENT_REMARKS
, BET.CHANGE_NOTICE
, LU11.MEANING BASIS_TYPE
, BET.COMPONENT_QUANTITY
, BET.OPERATION_LEAD_TIME_PERCENT
, BET.MUTUALLY_EXCLUSIVE_OPTIONS
, BET.CHECK_ATP
, BET.REQUIRED_TO_SHIP
, LU10.MEANING SO_BASIS
, BET.REQUIRED_FOR_REVENUE
, BET.INCLUDE_ON_SHIP_DOCS
, BET.LOW_QUANTITY MINIMUM_QUANTITY
, BET.HIGH_QUANTITY MAXIMUM_QUANTITY
, MSI.PRIMARY_UOM_CODE UNIT_OF_MEASURE
, MSI.ITEM_TYPE ITEM_TYPE
, MSI.DESCRIPTION
, MSI.ENG_ITEM_FLAG
, MSI.CUM_MANUFACTURING_LEAD_TIME
, MSI.CUMULATIVE_TOTAL_LEAD_TIME
, MSI.FULL_LEAD_TIME MANUFACTURING_LEAD_TIME
, BOM.ASSEMBLY_ITEM_ID PARENT_ITEM_ID
, BOM.ALTERNATE_BOM_DESIGNATOR PARENT_ALTERNATE
, BOM.ASSEMBLY_TYPE ENG_BILL
, LPAD(PLAN_LEVEL
, LEAST(PLAN_LEVEL
, 8)
, '.') DISPLAY_PLAN_LEVEL
, TO_CHAR(BET.EFFECTIVITY_DATE
, 'HH24:MI') EFFECTIVITY_TIME
, TO_CHAR(BET.DISABLE_DATE
, 'HH24:MI') DISABLE_TIME
, BET.EXTENDED_QUANTITY
, DECODE(BET.EXTEND_COST_FLAG
, 1
, BET.ITEM_COST * BET.EXTENDED_QUANTITY
, 2
, 0
, NULL) EXTENDED_COST
, BET.OPERATION_SEQ_NUM
, MSI.BOM_ITEM_TYPE BOM_ITEM_TYPE
, MSI.REPLENISH_TO_ORDER_FLAG ATO_FLAG
, MSI.PICK_COMPONENTS_FLAG
, MSI.ATP_COMPONENTS_FLAG
, MSI.ATP_FLAG
, MSI.SHIPPABLE_ITEM_FLAG
, MSI.MRP_PLANNING_CODE
, MSI.SO_TRANSACTIONS_FLAG
, MSI.CUSTOMER_ORDER_ENABLED_FLAG
, MSI.INVOICE_ENABLED_FLAG
, MSI.INVENTORY_ASSET_FLAG
, MSI.ITEM_NUMBER
, MSI.PADDED_ITEM_NUMBER
, BET.AUTO_REQUEST_MATERIAL
, BET.LOOP_FLAG
FROM BOM_EXPLOSION_TEMP BET
, MFG_LOOKUPS LU10
, BOM_STRUCTURES_B BOM
, MTL_ITEM_FLEXFIELDS MSI
, MFG_LOOKUPS LU11
WHERE BET.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND BET.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID
AND BET.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND LU10.LOOKUP_CODE(+) = BET.SO_BASIS
AND LU10.LOOKUP_TYPE(+) = 'BOM_SO_BASIS'
AND LU11.LOOKUP_CODE = NVL(BET.BASIS_TYPE
, 1)
AND LU11.LOOKUP_TYPE(+) ='BOM_BASIS_TYPE'

Columns