eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OE_ITEMS_ORD_MV

Object Details

Object Name:	OE_ITEMS_ORD_MV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_ITEMS_ORD_MV
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
ITEM	VARCHAR2	(1000)	Item
ITEM_ID	NUMBER		Item Id
ITEM_DESCRIPTION	VARCHAR2	(240)	Item Description
INVENTORY_ITEM_ID	NUMBER		Inventory Item Id
INVENTORY_ITEM	VARCHAR2	(1000)	Inventory Item
ITEM_IDENTIFIER_TYPE	VARCHAR2	(25)	Item Identifier Type
SOLD_TO_ORG_ID	NUMBER		Sold To Org Id
ORGANIZATION_ID	NUMBER		Organization Id
ITEM_STATUS	VARCHAR2	(10)	Item Status
CROSS_REF_STATUS	VARCHAR2	(10)	Cross Reference Status
ADDRESS	VARCHAR2	(1000)	Address
CUST_ADDRESS	VARCHAR2	(1000)	Customer Address
ITEM_DEFINITION_LEVEL	VARCHAR2	(100)	Item Definition Level
RANK	NUMBER		Rank
SITE_USE_ID	NUMBER		Site Use Id
ITEM_DEFINITION_LEVEL_CODE	VARCHAR2	(100)	Item Definition Level Code
LANGUAGE	VARCHAR2	(4)	Language
CATEGORY_ID	NUMBER		Category Id
ORG_INDEPENDENT_FLAG	VARCHAR2	(1)	Cross Reference Organization Independent Flag
CROSS_REF_ORG_ID	NUMBER		Cross Reference Organization Id

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ITEM
,      ITEM_ID
,      ITEM_DESCRIPTION
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM
,      ITEM_IDENTIFIER_TYPE
,      SOLD_TO_ORG_ID
,      ORGANIZATION_ID
,      ITEM_STATUS
,      CROSS_REF_STATUS
,      ADDRESS
,      CUST_ADDRESS
,      ITEM_DEFINITION_LEVEL
,      RANK
,      SITE_USE_ID
,      ITEM_DEFINITION_LEVEL_CODE
,      LANGUAGE
,      CATEGORY_ID
,      ORG_INDEPENDENT_FLAG
,      CROSS_REF_ORG_ID
FROM APPS.OE_ITEMS_ORD_MV;

Dependencies

[top of page]

APPS.OE_ITEMS_ORD_MV references the following:

APPS: OE_ITEMS_MV; OE_ITEM_ORDERABILITY; OE_ITEM_ORDERABILITY_RULES; OE_ITORD_UTIL - show dependent code

APPS.OE_ITEMS_ORD_MV is referenced by following:

APPS: OE_RELATED_ITEMS_MV