Product: | ASO - Order Capture |
---|---|
Description: | This is a view based on MTL_SYSTEM_ITEMS_VL which has System Items multilingual view with concatenated segments column |
Implementation/DBA Data: | APPS.ASO_I_ITEMS_V |
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, PRIMARY_UOM_CODE
, PRIMARY_UNIT_OF_MEASURE
, ITEM_TYPE
, INVENTORY_ITEM_STATUS_CODE
, ALLOWED_UNITS_LOOKUP_CODE
, ITEM_CATALOG_GROUP_ID
, CATALOG_STATUS_FLAG
, INVENTORY_ITEM_FLAG
, RESERVABLE_TYPE
, BOM_ENABLED_FLAG
, BOM_ITEM_TYPE
, BASE_ITEM_ID
, LIST_PRICE_PER_UNIT
, CUSTOMER_ORDER_FLAG
, CUSTOMER_ORDER_ENABLED_FLAG
, SHIPPABLE_ITEM_FLAG
, ATP_FLAG
, ATP_COMPONENTS_FLAG
, TAX_CODE
, SERVICE_ITEM_FLAG
, SERVICE_DURATION
, SERVICE_DURATION_PERIOD_CODE
, SERVICEABLE_PRODUCT_FLAG
, SERVICE_STARTING_DELAY
, SERVICEABLE_COMPONENT_FLAG
, SERVICEABLE_ITEM_CLASS_ID
, BASE_WARRANTY_SERVICE_ID
, SEGMENT1
, CONCATENATED_SEGMENTS
, PADDED_CONCATENATED_SEGMENTS
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, DESCRIPTION
, EVENT_FLAG
, COLLATERAL_FLAG
, ELECTRONIC_FLAG
, MTL_TRANSACTIONS_ENABLED_FLAG
FROM MTL_SYSTEM_ITEMS_VL