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

VIEW: APPS.CZ_RP_USG_DIRECTORY_V

Object Details
Object Name: CZ_RP_USG_DIRECTORY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCZ.CZ_RP_USG_DIRECTORY_V
Subobject Name:
Status: VALID

View Type

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


This view lists a directory of all the Usages in the Configurator Repository.


[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_TYPE VARCHAR2 (3) Yes Specifies the type of the associated object: in this view, only 'USG' for Usage
OBJECT_ID NUMBER (15) Yes Holds the identifier of this object as recorded in the source table, e.g., a devl_project_id
ENCLOSING_FOLDER NUMBER (9) Yes Identifies the Configurator repository Folder in which this object resides
NAME VARCHAR2 (255) Yes The name of this object
SYNOPSIS VARCHAR2 (489)
Summary descriptive information of the associated entity
DESCRIPTION VARCHAR2 (2000) Yes Descriptive text
DELETED_FLAG VARCHAR2 (1)
Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
CREATED_BY NUMBER (9) Yes Standard field recording the ID of the user that created this record
CREATION_DATE DATE
Yes Standard field recording the date this record was created
LAST_UPDATED_BY NUMBER (9) Yes Standard field recording the ID of the user that last updated this record
LAST_UPDATE_DATE DATE
Yes Standard field recording the date/time this record was last updated
Query Text

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


SELECT OBJECT_TYPE
,      OBJECT_ID
,      ENCLOSING_FOLDER
,      NAME
,      SYNOPSIS
,      DESCRIPTION
,      DELETED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.CZ_RP_USG_DIRECTORY_V;

Dependencies

[top of page]

APPS.CZ_RP_USG_DIRECTORY_V references the following:

SchemaAPPS
ViewCZ_MODEL_USAGES_VL
SynonymCZ_RP_ENTRIES
APPS.CZ_RP_USG_DIRECTORY_V is referenced by following:

SchemaAPPS
ViewCZ_RP_DIRECTORY_V