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

VIEW: APPS.CR_RSRC_DTL_VW1

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

View Type

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


NOT CURRENTLY USED.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCES VARCHAR2 (16) Yes Resource name
RESOURCE_DESC VARCHAR2 (40) Yes Description of the resource
DELETE_MARK NUMBER (22) Yes Indicator to show if the resource is marked for purge.
ORGN_CODE VARCHAR2 (4)
Organization code of the owner organization
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_VW1;

Dependencies

[top of page]

APPS.CR_RSRC_DTL_VW1 references the following:

SchemaAPPS
SynonymCR_RSRC_DTL
SynonymCR_RSRC_MST

APPS.CR_RSRC_DTL_VW1 is not referenced by any database object