Product: | ICX - Oracle iProcurement |
---|---|
Description: | Configurator Components View |
Implementation/DBA Data: | APPS.ICX_CONFIG_COMPONENTS_WEB_V |
SELECT BCE.ROWID ROW_ID
, BCE.COMPONENT_ITEM_ID
, BCE.ORGANIZATION_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NAME
, MSI.DESCRIPTION ITEM_DESCRIPTION
, BCE.LIST_PRICE
, BCE.SELLING_PRICE
, BCE.BOM_ITEM_TYPE
, BCE.OPTIONAL
, BCE.MUTUALLY_EXCLUSIVE_OPTIONS
, BCE.SORT_ORDER
, BCE.COMPONENT_QUANTITY
, BCE.PRIMARY_UOM_CODE
, BCE.PRIMARY_UNIT_OF_MEASURE
, BCE.PLAN_LEVEL
, DECODE(BCE.PLAN_LEVEL
, 0
, 'N'
, 'Y') DISPLAY_FLAG
, BCE.LOW_QUANTITY
, BCE.HIGH_QUANTITY
, BCE.EXTENDED_QUANTITY
, BCE.SO_BASIS
, BCE.COMPONENT_CODE
, BCE.CONTEXT
, BCE.ATTRIBUTE1
, BCE.ATTRIBUTE2
, BCE.ATTRIBUTE3
, BCE.ATTRIBUTE4
, BCE.ATTRIBUTE5
, BCE.ATTRIBUTE6
, BCE.ATTRIBUTE7
, BCE.ATTRIBUTE8
, BCE.ATTRIBUTE9
, BCE.ATTRIBUTE10
, BCE.ATTRIBUTE11
, BCE.ATTRIBUTE12
, BCE.ATTRIBUTE13
, BCE.ATTRIBUTE14
, BCE.ATTRIBUTE15
, BCE.SELECT_QUANTITY SELECTED_QTY
, BCE.SELECT_FLAG SELECTED_FLAG
, BCE.TOP_BILL_SEQUENCE_ID
, BCE.EFFECTIVITY_DATE
, BCE.DISABLE_DATE
, DECODE(NVL(BCE.ITEM_SVRID
, -1)
, -1
, 'N'
, 0
, 'N'
, 'Y') AUTOSELECTED_FLAG
, BCE.GROUP_ID
, BCE.SELECT_QUANTITY * BCE.SELLING_PRICE EXT_PRICE
, BCE.DATE_COL1 EARLIEST_ATP_DATE
, BCE.DATE_COL2 GROUP_ATP_DATE
, BCE.NUM_COL1 NUMBER_KIDS
FROM BOM_CONFIG_EXPLOSIONS BCE
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE MSI.INVENTORY_ITEM_ID = BCE.COMPONENT_ITEM_ID
AND MSI.ORGANIZATION_ID = BCE.ORGANIZATION_ID