eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.SO_CONFIG_COMPONENTS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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