VIEW: APPS.ASO_I_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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