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

VIEW: APPS.AMV_RS_ALL_RES_EXTNS_VL

Object Details
Object Name: AMV_RS_ALL_RES_EXTNS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMV.AMV_RS_ALL_RES_EXTNS_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

MultiLingual view (a language resolved view of the data.)


View based on jtf_rs_resource_extns


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Yes Resource Identifier
CATEGORY VARCHAR2 (30) Yes Category
RESOURCE_NUMBER VARCHAR2 (30) Yes Resource Number
RESOURCE_NAME VARCHAR2 (360)
Resource Name
SOURCE_ID NUMBER

Source Identifier
FULL_NAME VARCHAR2 (360)
Full Name
FIRST_NAME VARCHAR2 (360)
First Name
MIDDLE_NAME VARCHAR2 (360)
Middle Name
LAST_NAME VARCHAR2 (360)
Last Name
EMAIL VARCHAR2 (2000)
Email
START_DATE_ACTIVE DATE
Yes Start Date Active
END_DATE_ACTIVE DATE

End Date Active
PHONE VARCHAR2 (2000)
Phone
USER_ID NUMBER

User Identifier
Query Text

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


SELECT RESOURCE_ID
,      CATEGORY
,      RESOURCE_NUMBER
,      RESOURCE_NAME
,      SOURCE_ID
,      FULL_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      EMAIL
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PHONE
,      USER_ID
FROM APPS.AMV_RS_ALL_RES_EXTNS_VL;

Dependencies

[top of page]

APPS.AMV_RS_ALL_RES_EXTNS_VL references the following:

SchemaAPPS
SynonymJTF_RS_RESOURCE_EXTNS
APPS.AMV_RS_ALL_RES_EXTNS_VL is referenced by following:

SchemaAPPS
Package BodyAMV_MATCH_PVT - show dependent code
Package BodyAMV_MYCHANNEL_PVT - show dependent code
Package BodyAMV_USER_PVT - show dependent code