View: SO_CONFIG_COMPONENTS_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_CONFIG_COMPONENTS_V

View Text

SELECT DISTINCT BE.ROWID
, BE.TOP_BILL_SEQUENCE_ID
, BE.BILL_SEQUENCE_ID
, BE.ORGANIZATION_ID
, BE.COMPONENT_SEQUENCE_ID
, BE.COMPONENT_ITEM_ID
, MSIV.DESCRIPTION
, MSI.CONCATENATED_SEGMENTS
, BE.PLAN_LEVEL
, NULL
, NULL
, BE.EXTENDED_QUANTITY
, BE.SORT_ORDER
, BE.EXPLODE_GROUP_ID
, BE.TOP_ITEM_ID
, BE.CONTEXT
, BE.ATTRIBUTE1
, BE.ATTRIBUTE2
, BE.ATTRIBUTE3
, BE.ATTRIBUTE4
, BE.ATTRIBUTE5
, BE.ATTRIBUTE6
, BE.ATTRIBUTE7
, BE.ATTRIBUTE8
, BE.ATTRIBUTE9
, BE.ATTRIBUTE10
, BE.ATTRIBUTE11
, BE.ATTRIBUTE12
, BE.ATTRIBUTE13
, BE.ATTRIBUTE14
, BE.ATTRIBUTE15
, BE.COMPONENT_QUANTITY
, BE.SO_BASIS
, BE.OPTIONAL
, DECODE( BE.BOM_ITEM_TYPE
, 1
, DECODE( BE.MUTUALLY_EXCLUSIVE_OPTIONS
, 1
, '3'
, '2' )
, 2
, DECODE( BE.MUTUALLY_EXCLUSIVE_OPTIONS
, 1
, '3'
, '2' )
, DECODE( BIC.MUTUALLY_EXCLUSIVE_OPTIONS
, 1
, '1'
, '2' ) )
, BE.CHECK_ATP
, BE.SHIPPING_ALLOWED
, BE.REQUIRED_TO_SHIP
, BE.REQUIRED_FOR_REVENUE
, BE.INCLUDE_ON_SHIP_DOCS
, BE.INCLUDE_ON_BILL_DOCS
, BE.LOW_QUANTITY
, BE.HIGH_QUANTITY
, BE.PICK_COMPONENTS
, BE.PRIMARY_UOM_CODE
, BE.PRIMARY_UNIT_OF_MEASURE
, BE.BASE_ITEM_ID
, BE.ATP_COMPONENTS_FLAG
, BE.ATP_FLAG
, BE.BOM_ITEM_TYPE
, DECODE( BE.BOM_ITEM_TYPE
, 1
, 1
, 2
, 2
, 4
, DECODE( BE.OPTIONAL
, 1
, 3
, 6 ) )
, BE.PICK_COMPONENTS_FLAG
, BE.CUSTOMER_ORDER_FLAG
, BE.INTERNAL_ORDER_FLAG
, BE.CUSTOMER_ORDER_ENABLED_FLAG
, BE.INTERNAL_ORDER_ENABLED_FLAG
, BE.SO_TRANSACTIONS_FLAG
, BE.DESCRIPTION
, BE.ASSEMBLY_ITEM_ID
, BE.COMPONENT_CODE
, BE.LOOP_FLAG
, BE.OPERATION_SEQ_NUM
, BE.PARENT_BOM_ITEM_TYPE
, BE.ITEM_NUM
, BE.EFFECTIVITY_DATE
, BE.DISABLE_DATE
, BE.IMPLEMENTATION_DATE
, BE.REXPLODE_FLAG
, BE.COMMON_BILL_SEQUENCE_ID
, BE.EXPLOSION_TYPE
, BE.REPLENISH_TO_ORDER_FLAG
, BE.SHIPPABLE_ITEM_FLAG
, BE.COMP_BILL_SEQ_ID
, BE.COMP_COMMON_BILL_SEQ_ID
, BE.NUM_COL1
, BE.NUM_COL2
, BE.NUM_COL3
, BE.CHAR_COL1
, BE.CHAR_COL2
, BE.CHAR_COL3
, BE.DATE_COL1
, BE.DATE_COL2
, BE.DATE_COL3
, NULL
FROM BOM_EXPLOSIONS BE
, BOM_EXPLOSIONS BEP
, BOM_INVENTORY_COMPONENTS BIC
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_SYSTEM_ITEMS_VL MSIV
WHERE MSI.INVENTORY_ITEM_ID = BE.COMPONENT_ITEM_ID
AND MSI.ORGANIZATION_ID = BE.ORGANIZATION_ID
AND MSIV.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSIV.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND NVL( BEP.EXPLODE_GROUP_ID
, -99 ) = NVL(BE.EXPLODE_GROUP_ID
, -99)
AND BEP.EXPLOSION_TYPE = BE.EXPLOSION_TYPE
AND BEP.TOP_BILL_SEQUENCE_ID = BE.TOP_BILL_SEQUENCE_ID
AND BE.PLAN_LEVEL > 0
AND BEP.PLAN_LEVEL = BE.PLAN_LEVEL - 1
AND BEP.SORT_ORDER = SUBSTR(BE.SORT_ORDER
, 1
, (LENGTH(BE.SORT_ORDER)-4))
AND BIC.COMPONENT_SEQUENCE_ID = DECODE(BE.PLAN_LEVEL
, 1
, BE.COMPONENT_SEQUENCE_ID
, BEP.COMPONENT_SEQUENCE_ID ) UNION SELECT DISTINCT BE.ROWID
, BE.TOP_BILL_SEQUENCE_ID
, BE.BILL_SEQUENCE_ID
, BE.ORGANIZATION_ID
, BE.COMPONENT_SEQUENCE_ID
, BE.COMPONENT_ITEM_ID
, MSI.DESCRIPTION
, MSI.CONCATENATED_SEGMENTS
, BE.PLAN_LEVEL
, NULL
, NULL
, BE.EXTENDED_QUANTITY
, BE.SORT_ORDER
, BE.EXPLODE_GROUP_ID
, BE.TOP_ITEM_ID
, BE.CONTEXT
, BE.ATTRIBUTE1
, BE.ATTRIBUTE2
, BE.ATTRIBUTE3
, BE.ATTRIBUTE4
, BE.ATTRIBUTE5
, BE.ATTRIBUTE6
, BE.ATTRIBUTE7
, BE.ATTRIBUTE8
, BE.ATTRIBUTE9
, BE.ATTRIBUTE10
, BE.ATTRIBUTE11
, BE.ATTRIBUTE12
, BE.ATTRIBUTE13
, BE.ATTRIBUTE14
, BE.ATTRIBUTE15
, BE.COMPONENT_QUANTITY
, BE.SO_BASIS
, BE.OPTIONAL
, DECODE( BE.BOM_ITEM_TYPE
, 1
, DECODE( BE.MUTUALLY_EXCLUSIVE_OPTIONS
, 1
, '3'
, '2' )
, 2
, DECODE( BE.MUTUALLY_EXCLUSIVE_OPTIONS
, 1
, '3'
, '2' ) )
, BE.CHECK_ATP
, BE.SHIPPING_ALLOWED
, BE.REQUIRED_TO_SHIP
, BE.REQUIRED_FOR_REVENUE
, BE.INCLUDE_ON_SHIP_DOCS
, BE.INCLUDE_ON_BILL_DOCS
, BE.LOW_QUANTITY
, BE.HIGH_QUANTITY
, BE.PICK_COMPONENTS
, BE.PRIMARY_UOM_CODE
, BE.PRIMARY_UNIT_OF_MEASURE
, BE.BASE_ITEM_ID
, BE.ATP_COMPONENTS_FLAG
, BE.ATP_FLAG
, BE.BOM_ITEM_TYPE
, DECODE( BE.BOM_ITEM_TYPE
, 1
, 1
, 2
, 2
, 4
, DECODE( BE.OPTIONAL
, 1
, 3
, 6 ) )
, BE.PICK_COMPONENTS_FLAG
, BE.CUSTOMER_ORDER_FLAG
, BE.INTERNAL_ORDER_FLAG
, BE.CUSTOMER_ORDER_ENABLED_FLAG
, BE.INTERNAL_ORDER_ENABLED_FLAG
, BE.SO_TRANSACTIONS_FLAG
, BE.DESCRIPTION
, BE.ASSEMBLY_ITEM_ID
, BE.COMPONENT_CODE
, BE.LOOP_FLAG
, BE.OPERATION_SEQ_NUM
, BE.PARENT_BOM_ITEM_TYPE
, BE.ITEM_NUM
, BE.EFFECTIVITY_DATE
, BE.DISABLE_DATE
, BE.IMPLEMENTATION_DATE
, BE.REXPLODE_FLAG
, BE.COMMON_BILL_SEQUENCE_ID
, BE.EXPLOSION_TYPE
, BE.REPLENISH_TO_ORDER_FLAG
, BE.SHIPPABLE_ITEM_FLAG
, BE.COMP_BILL_SEQ_ID
, BE.COMP_COMMON_BILL_SEQ_ID
, BE.NUM_COL1
, BE.NUM_COL2
, BE.NUM_COL3
, BE.CHAR_COL1
, BE.CHAR_COL2
, BE.CHAR_COL3
, BE.DATE_COL1
, BE.DATE_COL2
, BE.DATE_COL3
, NULL
FROM BOM_EXPLOSIONS BE
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE MSI.INVENTORY_ITEM_ID = BE.COMPONENT_ITEM_ID
AND MSI.ORGANIZATION_ID = BE.ORGANIZATION_ID
AND BE.PLAN_LEVEL = 0

Columns