[Home] [Help]
| Product: | BOM - Bills of Material |
|---|---|
| Description: | Autoselection items |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AI.ROWID
, AI.AUTOSELECTION_ID
, AI.RANGE_ID
, AI.ASSIGNMENT_ID
, AI.LAST_UPDATE_DATE
, AI.LAST_UPDATED_BY
, AI.CREATION_DATE
, AI.CREATED_BY
, AI.LAST_UPDATE_LOGIN
, AI.ORGANIZATION_ID
, AI.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.PRIMARY_UNIT_OF_MEASURE
, AI.QUANTITY
, AI.COMPONENT_CODE
, AI.PRICE_FLAG
, AI.EFFECTIVITY_DATE
, AI.DISABLE_DATE
, AI.COMPONENT_SORT_CODE
, AI.OPT_ATTRIBUTE_CODE
, AI.AUTOSELECT_ON_BOOK
, AI.ATTRIBUTE_CATEGORY
, AI.ATTRIBUTE1
, AI.ATTRIBUTE2
, AI.ATTRIBUTE3
, AI.ATTRIBUTE4
, AI.ATTRIBUTE5
, AI.ATTRIBUTE6
, AI.ATTRIBUTE7
, AI.ATTRIBUTE8
, AI.ATTRIBUTE9
, AI.ATTRIBUTE10
, AI.ATTRIBUTE11
, AI.ATTRIBUTE12
, AI.ATTRIBUTE13
, AI.ATTRIBUTE14
, AI.ATTRIBUTE15
FROM MTL_SYSTEM_ITEMS_KFV MSI
, CZ_AUTOSELECTION_ITEMS AI
WHERE AI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND AI.ORGANIZATION_ID = MSI.ORGANIZATION_ID