[Home] [Help] [Dependency Information]
Object Name: | ASO_I_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ASO.ASO_I_ITEMS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary unit of measure code | |
PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Primary stocking unit of measure for the item | |
ITEM_TYPE | VARCHAR2 | (30) | User defined item type | |
INVENTORY_ITEM_STATUS_CODE | VARCHAR2 | (10) | Yes | Material status code |
ALLOWED_UNITS_LOOKUP_CODE | NUMBER | Allowed unit of measure conversion type | ||
ITEM_CATALOG_GROUP_ID | NUMBER | Item catalog group identifier | ||
CATALOG_STATUS_FLAG | VARCHAR2 | (1) | Flag indicating item catalog complete | |
INVENTORY_ITEM_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item may appear on invoices |
RESERVABLE_TYPE | NUMBER | Hard reservations allowed flag | ||
BOM_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item may appear on a BOM |
BOM_ITEM_TYPE | NUMBER | Yes | Type of item | |
BASE_ITEM_ID | NUMBER | Base item identifier | ||
LIST_PRICE_PER_UNIT | NUMBER | Unit list price - purchasing | ||
CUSTOMER_ORDER_FLAG | VARCHAR2 | (1) | Yes | Flag indicating customer orderable item |
CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Customer Order Enabled Flag |
SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | Yes | Flag indicating shippable item |
ATP_FLAG | VARCHAR2 | (1) | Yes | Flag indicating ATP must be checked when item is ordered |
ATP_COMPONENTS_FLAG | VARCHAR2 | (1) | Yes | Flag indicating whether item may have components requiring ATP check |
TAX_CODE | VARCHAR2 | (50) | Tax code | |
SERVICE_ITEM_FLAG | VARCHAR2 | (1) | Yes | Flag indicating service item |
SERVICE_DURATION | NUMBER | Default service duration | ||
SERVICE_DURATION_PERIOD_CODE | VARCHAR2 | (10) | Period code for default service duration | |
SERVICEABLE_PRODUCT_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the item is serviceable by other service-type items and can have service requests reported against it |
SERVICE_STARTING_DELAY | NUMBER | Days after shipment that service begins | ||
SERVICEABLE_COMPONENT_FLAG | VARCHAR2 | (1) | Indicates whether the item is serviceable by other service-type items and whether it can be referenced as the component of another item | |
SERVICEABLE_ITEM_CLASS_ID | NUMBER | Serviceable item class identifier | ||
BASE_WARRANTY_SERVICE_ID | NUMBER | Base warranty identifier | ||
SEGMENT1 | VARCHAR2 | (40) | Key flexfield segment | |
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | ||
PADDED_CONCATENATED_SEGMENTS | VARCHAR2 | (40) | ||
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Flexfield summary flag |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flexfield segment enabled flag |
START_DATE_ACTIVE | DATE | Flexfield segment start date | ||
END_DATE_ACTIVE | DATE | Flexfield segment end date | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Global Descriptive flexfield structure defining column | |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Global Descriptive flexfield segment | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Global Descriptive flexfield segment | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Global Descriptive flexfield segment | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Global Descriptive flexfield segment | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Global Descriptive flexfield segment | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Global Descriptive flexfield segment | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Global Descriptive flexfield segment | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Global Descriptive flexfield segment | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Global Descriptive flexfield segment | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Global Descriptive flexfield segment | |
DESCRIPTION | VARCHAR2 | (240) | Item description | |
EVENT_FLAG | VARCHAR2 | (1) | Event Flag | |
COLLATERAL_FLAG | VARCHAR2 | (1) | Flag indicating item is collateral item | |
ELECTRONIC_FLAG | VARCHAR2 | (1) | Electronic Flag | |
MTL_TRANSACTIONS_ENABLED_FLAG | VARCHAR2 | (1) | Yes |
Cut, paste (and edit) the following text to query this object:
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 APPS.ASO_I_ITEMS_V;
|
|
|