[Home] [Help] [Dependency Information]
Object Name: | OKE_SYSTEM_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKE.OKE_SYSTEM_ITEMS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID1 | NUMBER | Yes | Inventory item unique identifier | |
ID2 | NUMBER | Yes | Inventory organization unique identifier | |
NAME | VARCHAR2 | (40) | Item number | |
DESCRIPTION | VARCHAR2 | (240) | Description of item | |
CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating whether item is enabled for customer orders |
PURCHASING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating whether item is enabled for purchasing |
SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | Yes | Shippable item indicator |
INVOICEABLE_ITEM_FLAG | VARCHAR2 | (1) | Yes | Invoiceable item indicator |
EFFECTIVITY_CONTROL | NUMBER | Effective control of the item, either date or model/unit | ||
ITEM_TYPE | VARCHAR2 | (30) | Item type | |
B_STATUS | VARCHAR2 | (1) | Yes | Item status |
STATUS | VARCHAR2 | (1) | Item status | |
START_DATE_ACTIVE | DATE | Date this item becomes active | ||
END_DATE_ACTIVE | DATE | Date this item becomes inactive | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary unit of measure for item | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item unique identifier | |
ORGANIZATION_ID | NUMBER | Yes | Inventory organization unique identifier | |
INVENTORY_ITEM_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if inventory item |
Cut, paste (and edit) the following text to query this object:
SELECT ID1
, ID2
, NAME
, DESCRIPTION
, CUSTOMER_ORDER_ENABLED_FLAG
, PURCHASING_ENABLED_FLAG
, SHIPPABLE_ITEM_FLAG
, INVOICEABLE_ITEM_FLAG
, EFFECTIVITY_CONTROL
, ITEM_TYPE
, B_STATUS
, STATUS
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PRIMARY_UOM_CODE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_FLAG
FROM APPS.OKE_SYSTEM_ITEMS_V;
|
|
|