Product: | ICX - Oracle iProcurement |
---|---|
Description: | Java Configurator Error Messages Validation View |
Implementation/DBA Data: | Not implemented in this database |
SELECT DISTINCT BCEC.ROWID ROW_ID
, BCEC.COMPONENT_ITEM_ID
, BCEC.ORGANIZATION_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NAME
, MSI.DESCRIPTION ITEM_DESCRIPTION
, BCEC.LIST_PRICE
, BCEC.SELLING_PRICE
, BCEC.BOM_ITEM_TYPE
, BCEC.OPTIONAL
, BCEC.MUTUALLY_EXCLUSIVE_OPTIONS
, BCEC.SORT_ORDER
, BCEC.COMPONENT_QUANTITY
, BCEC.PRIMARY_UOM_CODE
, BCEC.PRIMARY_UNIT_OF_MEASURE
, BCEC.PLAN_LEVEL
, DECODE(BCEC.PLAN_LEVEL
, 0
, 'N'
, 'Y') DISPLAY_FLAG
, BCEC.LOW_QUANTITY
, BCEC.HIGH_QUANTITY
, BCEC.EXTENDED_QUANTITY
, BCEC.SO_BASIS
, BCEC.COMPONENT_CODE
, BCEC.CONTEXT
, BCEC.ATTRIBUTE1
, BCEC.ATTRIBUTE2
, BCEC.ATTRIBUTE3
, BCEC.ATTRIBUTE4
, BCEC.ATTRIBUTE5
, BCEC.ATTRIBUTE6
, BCEC.ATTRIBUTE7
, BCEC.ATTRIBUTE8
, BCEC.ATTRIBUTE9
, BCEC.ATTRIBUTE10
, BCEC.ATTRIBUTE11
, BCEC.ATTRIBUTE12
, BCEC.ATTRIBUTE13
, BCEC.ATTRIBUTE14
, BCEC.ATTRIBUTE15
, BCEC.SELECT_QUANTITY SELECTED_QUANTITY
, BCEC.SELECT_FLAG SELECTED_FLAG
, BCEC.TOP_BILL_SEQUENCE_ID
, BCEC.EFFECTIVITY_DATE
, BCEC.DISABLE_DATE
, BCEC.GROUP_ID
, AIAV.ATTRIBUTE_CODE
, CE.ASSIGNMENT_ID
, BCEC.SELECT_QUANTITY*BCEC.SELLING_PRICE EXT_PRICE
FROM AK_ATTRIBUTES AK
, AK_OBJECT_ATTRIBUTES AOA
, AK_INST_ATTRIBUTE_VALUES AIAV
, BOM_CONFIG_EXPLOSIONS BCEC
, BOM_CONFIG_EXPLOSIONS BCE
, MTL_SYSTEM_ITEMS_KFV MSI
, CZ_ERRORS CE
WHERE CE.GROUP_ID = BCEC.GROUP_ID
AND BCEC.GROUP_ID = BCE.GROUP_ID
AND ( BCEC.SORT_ORDER = BCE.SORT_ORDER OR SUBSTR(BCEC.SORT_ORDER
, 1
, LENGTH(BCEC.SORT_ORDER)-3) = BCE.SORT_ORDER )
AND BCEC.COMPONENT_ITEM_ID = AIAV.KEY_VALUE2
AND BCEC.ORGANIZATION_ID = AIAV.KEY_VALUE1
AND MSI.INVENTORY_ITEM_ID = BCEC.COMPONENT_ITEM_ID
AND MSI.ORGANIZATION_ID = BCEC.ORGANIZATION_ID
AND AIAV.DATABASE_OBJECT_NAME ='MTL_SYSTEM_ITEMS_KFV'
AND AIAV.ATTRIBUTE_APPLICATION_ID=702
AND AIAV.ATTRIBUTE_CODE = AOA.ATTRIBUTE_CODE
AND AOA.ATTRIBUTE_APPLICATION_ID = 702
AND AOA.DATABASE_OBJECT_NAME = AIAV.DATABASE_OBJECT_NAME
AND AK.ATTRIBUTE_CODE = AIAV.ATTRIBUTE_CODE
AND AK.ATTRIBUTE_APPLICATION_ID = 702
AND AIAV.ATTRIBUTE_CODE IN ( SELECT ATTRIBUTE_CODE1
FROM CZ_CONSTRAINT_CLAUSES CC
, CZ_CONSTRAINT_ASSIGNMENTS CCA
WHERE CCA.ASSIGNMENT_ID = CE.ASSIGNMENT_ID
AND CCA.CONSTRAINT_ID = CC.CONSTRAINT_ID UNION SELECT ATTRIBUTE_CODE2
FROM CZ_CONSTRAINT_CLAUSES CC
, CZ_CONSTRAINT_ASSIGNMENTS CCA
WHERE CCA.ASSIGNMENT_ID = CE.ASSIGNMENT_ID
AND CCA.CONSTRAINT_ID = CC.CONSTRAINT_ID )