VIEW: APPS.BOM_EXPLOSION_VIEW

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'