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


VIEW: APPS.MSC_COLL_ENTITIES_V

Object Details
Object Name: MSC_COLL_ENTITIES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


Collections entities


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes LOOKUP TYPE
SERIAL_NO VARCHAR2 (30) Yes Serial Number
ENTITY_NAME VARCHAR2 (80) Yes Entity Name
ENTITY_DESCRIPTION VARCHAR2 (240)
Entity Description
NETCHANGE_SUPPORT VARCHAR2 (150)
Netchange Supported
SNAPSHOT_USAGE VARCHAR2 (150)
Snapshot Usage
SNAPSHOT_GROUP_STRING VARCHAR2 (150)
Snapshot Group String
SNAPSHOT_GROUP_DISPLAY VARCHAR2 (150)
Snapshot Group display
Query Text

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


SELECT LOOKUP_TYPE
,      SERIAL_NO
,      ENTITY_NAME
,      ENTITY_DESCRIPTION
,      NETCHANGE_SUPPORT
,      SNAPSHOT_USAGE
,      SNAPSHOT_GROUP_STRING
,      SNAPSHOT_GROUP_DISPLAY
FROM APPS.MSC_COLL_ENTITIES_V;

Dependencies

[top of page]

APPS.MSC_COLL_ENTITIES_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.MSC_COLL_ENTITIES_V is referenced by following:

SchemaAPPS
ViewMRP_CL_REFRESH_COLL_SNAPSHOT_V