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

VIEW: APPS.OE_ITEMS_V

Object Details
Object Name: OE_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_ITEMS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is used to get list of inventory items, customer items and generic items.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM VARCHAR2 (255)
Item
ITEM_ID NUMBER

Item identifier for the given item identifier type.
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
INVENTORY_ITEM_ID NUMBER

Corresponding unique inventory item identifier
INVENTORY_ITEM VARCHAR2 (40)
Corresponding inventory item
ITEM_IDENTIFIER_TYPE VARCHAR2 (25)
INT(ernal), CUST(omer) or a generic type
SOLD_TO_ORG_ID NUMBER

Customer identifier for customer items, otherwise NULL
ORGANIZATION_ID NUMBER

Inventory validation organization identifier
ITEM_STATUS VARCHAR2 (8)
ACTIVE/INACTIVE for customer items, otherwise NULL
CROSS_REF_STATUS VARCHAR2 (8)
ACTIVE/INACTIVE for customer items, otherwise NULL
ADDRESS VARCHAR2 (480)
Customer Address, which is concatenation of Address Line 1 and Address Line 2.
CUST_ADDRESS VARCHAR2 (180)
Address or Category Name based on item definition level. Which is a concatenation of City, State and zip Code. Category Name for Category Level.
ITEM_DEFINITION_LEVEL VARCHAR2 (80)
Customer item defined level
RANK NUMBER

Rank
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
FROM APPS.OE_ITEMS_V;

Dependencies

[top of page]

APPS.OE_ITEMS_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
ViewFND_LOOKUP_VALUES_VL
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES
SynonymMTL_CROSS_REFERENCES
SynonymMTL_CROSS_REFERENCE_TYPES
SynonymMTL_CUSTOMER_ITEMS
SynonymMTL_CUSTOMER_ITEM_XREFS
SynonymMTL_PARAMETERS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_SYSTEM_ITEMS_TL
PL/SQL PackageOE_SYS_PARAMETERS - show dependent code
APPS.OE_ITEMS_V is referenced by following:

SchemaAPPS
PL/SQL PackageOE_SERVICE_UTIL - show dependent code