VIEW: APPS.ICX_CONFIG_COMPONENTS_WEB_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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