DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKE_SYSTEM_ITEMS_V

Object Details
Object Name: OKE_SYSTEM_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKE.OKE_SYSTEM_ITEMS_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.OKE_SYSTEM_ITEMS_V references the following:

SchemaAPPS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_SYSTEM_ITEMS_TL
APPS.OKE_SYSTEM_ITEMS_V is referenced by following:

SchemaAPPS
Package BodyOKE_ACTION_VALIDATIONS_PKG - show dependent code
Package BodyOKE_AMG_GRP - show dependent code
Package BodyOKE_CLE_PVT - show dependent code
Package BodyOKE_DEFAULTING_PKG - show dependent code
Package BodyOKE_DELIVERABLE_PVT - show dependent code
Package BodyOKE_DELIVERABLE_UTILS_PUB - show dependent code
Package BodyOKE_DTS_ACTION_PKG - show dependent code
ViewOKE_DTS_SEARCH_LOV_V
Package BodyOKE_DTS_WORKFLOW - show dependent code
Package BodyOKE_IMPORT_CONTRACT_PUB - show dependent code
Package BodyOKE_VERSION_COMPARISON_PKG - show dependent code