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

VIEW: APPS.OE_ITEMS_MV#

Object Details
Object Name: OE_ITEMS_MV#
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

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

ITEM_DESCRIPTION VARCHAR2 (240)
INVENTORY_ITEM_ID NUMBER

INVENTORY_ITEM VARCHAR2 (1000)
ITEM_IDENTIFIER_TYPE VARCHAR2 (25)
SOLD_TO_ORG_ID NUMBER

ORGANIZATION_ID NUMBER

ITEM_STATUS VARCHAR2 (10)
CROSS_REF_STATUS VARCHAR2 (10)
ADDRESS VARCHAR2 (1000)
CUST_ADDRESS VARCHAR2 (1000)
ITEM_DEFINITION_LEVEL VARCHAR2 (100)
RANK NUMBER

SITE_USE_ID NUMBER

ITEM_DEFINITION_LEVEL_CODE VARCHAR2 (100)
LANGUAGE VARCHAR2 (4)
CATEGORY_ID NUMBER

ORG_INDEPENDENT_FLAG VARCHAR2 (1)
CROSS_REF_ORG_ID NUMBER

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_MV#;

Dependencies

[top of page]

APPS.OE_ITEMS_MV# 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_B
SynonymMTL_CROSS_REFERENCES_TL
SynonymMTL_CROSS_REFERENCE_TYPES
SynonymMTL_CUSTOMER_ITEMS
SynonymMTL_CUSTOMER_ITEM_XREFS
SynonymMTL_DEFAULT_CATEGORY_SETS
SynonymMTL_ITEM_CATEGORIES
SynonymMTL_PARAMETERS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_SYSTEM_ITEMS_TL

APPS.OE_ITEMS_MV# is not referenced by any database object