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


VIEW: APPS.CST_XLA_INV_CATEGORY_REF_V

Object Details
Object Name: CST_XLA_INV_CATEGORY_REF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_XLA_INV_CATEGORY_REF_V
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 Mandatory Comments
CATEGORY_ID NUMBER
Yes
CATEGORY_ITEM_ID NUMBER
Yes
CATEGORY_ORGANIZATION_ID NUMBER
Yes
ITEM_CATEGORY_ATTR_CATEGORY VARCHAR2 (30)
ITEM_CATEGORY_ATTRIBUTE1 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE2 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE3 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE4 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE5 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE6 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE7 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE8 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE9 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE10 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE11 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE12 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE13 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE14 VARCHAR2 (150)
ITEM_CATEGORY_ATTRIBUTE15 VARCHAR2 (150)
ITEM_CATEGORY_SEGMENT1 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT2 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT3 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT4 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT5 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT6 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT7 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT8 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT9 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT10 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT11 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT12 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT13 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT14 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT15 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT16 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT17 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT18 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT19 VARCHAR2 (40)
ITEM_CATEGORY_SEGMENT20 VARCHAR2 (40)
Query Text

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


SELECT CATEGORY_ID
,      CATEGORY_ITEM_ID
,      CATEGORY_ORGANIZATION_ID
,      ITEM_CATEGORY_ATTR_CATEGORY
,      ITEM_CATEGORY_ATTRIBUTE1
,      ITEM_CATEGORY_ATTRIBUTE2
,      ITEM_CATEGORY_ATTRIBUTE3
,      ITEM_CATEGORY_ATTRIBUTE4
,      ITEM_CATEGORY_ATTRIBUTE5
,      ITEM_CATEGORY_ATTRIBUTE6
,      ITEM_CATEGORY_ATTRIBUTE7
,      ITEM_CATEGORY_ATTRIBUTE8
,      ITEM_CATEGORY_ATTRIBUTE9
,      ITEM_CATEGORY_ATTRIBUTE10
,      ITEM_CATEGORY_ATTRIBUTE11
,      ITEM_CATEGORY_ATTRIBUTE12
,      ITEM_CATEGORY_ATTRIBUTE13
,      ITEM_CATEGORY_ATTRIBUTE14
,      ITEM_CATEGORY_ATTRIBUTE15
,      ITEM_CATEGORY_SEGMENT1
,      ITEM_CATEGORY_SEGMENT2
,      ITEM_CATEGORY_SEGMENT3
,      ITEM_CATEGORY_SEGMENT4
,      ITEM_CATEGORY_SEGMENT5
,      ITEM_CATEGORY_SEGMENT6
,      ITEM_CATEGORY_SEGMENT7
,      ITEM_CATEGORY_SEGMENT8
,      ITEM_CATEGORY_SEGMENT9
,      ITEM_CATEGORY_SEGMENT10
,      ITEM_CATEGORY_SEGMENT11
,      ITEM_CATEGORY_SEGMENT12
,      ITEM_CATEGORY_SEGMENT13
,      ITEM_CATEGORY_SEGMENT14
,      ITEM_CATEGORY_SEGMENT15
,      ITEM_CATEGORY_SEGMENT16
,      ITEM_CATEGORY_SEGMENT17
,      ITEM_CATEGORY_SEGMENT18
,      ITEM_CATEGORY_SEGMENT19
,      ITEM_CATEGORY_SEGMENT20
FROM APPS.CST_XLA_INV_CATEGORY_REF_V;

Dependencies

[top of page]

APPS.CST_XLA_INV_CATEGORY_REF_V references the following:

SchemaAPPS
SynonymMTL_CATEGORIES
SynonymMTL_DEFAULT_CATEGORY_SETS
SynonymMTL_ITEM_CATEGORIES

APPS.CST_XLA_INV_CATEGORY_REF_V is not referenced by any database object