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

VIEW: APPS.CR_RSRC_DTL_VW2

Object Details
Object Name: CR_RSRC_DTL_VW2
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMP.CR_RSRC_DTL_VW2
Subobject Name:
Status: VALID

View Type

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


View for identifying group reources.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCES VARCHAR2 (16) Yes Resource name.
RESOURCE_DESC VARCHAR2 (240) Yes Resource description.
DELETE_MARK NUMBER (22) Yes Delete mark. 0=not deleted, 1=deleted.
ORGN_CODE VARCHAR2 (4)
Organization code.
Query Text

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


SELECT RESOURCES
,      RESOURCE_DESC
,      DELETE_MARK
,      ORGN_CODE
FROM APPS.CR_RSRC_DTL_VW2;

Dependencies

[top of page]

APPS.CR_RSRC_DTL_VW2 references the following:

SchemaAPPS
SynonymCR_RSRC_DTL
SynonymCR_RSRC_MST

APPS.CR_RSRC_DTL_VW2 is not referenced by any database object