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

VIEW: APPS.AMS_MTL_CATEGORIES_DENORM_VL

Object Details
Object Name: AMS_MTL_CATEGORIES_DENORM_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_MTL_CATEGORIES_DENORM_VL
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
ROW_ID ROWID (10)
Unique identifier generated by the database
CATEGORY_ID NUMBER
Yes Category Identifier
STRUCTURE_ID NUMBER
Yes Structure identifier
CONCATENATED_IDS VARCHAR2 (4000)
Concatenated identifiers of each category segment
CONCATENATED_DESCRIPTION VARCHAR2 (4000)
Concatenated desription of each category segment
Query Text

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


SELECT ROW_ID
,      CATEGORY_ID
,      STRUCTURE_ID
,      CONCATENATED_IDS
,      CONCATENATED_DESCRIPTION
FROM APPS.AMS_MTL_CATEGORIES_DENORM_VL;

Dependencies

[top of page]

APPS.AMS_MTL_CATEGORIES_DENORM_VL references the following:

SchemaAPPS
SynonymAMS_MTL_CATEGORIES_DENORM_B
SynonymAMS_MTL_CATEGORIES_DENORM_TL
APPS.AMS_MTL_CATEGORIES_DENORM_VL is referenced by following:

SchemaAPPS
Package BodyAMS_ACTPRODUCT_PVT - show dependent code