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

VIEW: APPS.PA_PROJ_REQUEST_DIRECTORY_V

Object Details
Object Name: PA_PROJ_REQUEST_DIRECTORY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_PROJ_REQUEST_DIRECTORY_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


PA_PROJ_REQUEST_DIRECTORY_V selects all the attributes of project requests.


[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15)
Unique identifier of the project request
RESOURCE_ID NUMBER

Unique identifier of the resource
RESOURCE_NAME VARCHAR2 (360)
Name of the resource
PROJECT_ROLE_ID VARCHAR2 (240)
Unique identifier of the project role
PROJECT_ROLE_NAME VARCHAR2 (240)
Name of the project role
SOURCE_ROLE_CODE VARCHAR2 (30)
Unique identifier of the source role
SOURCE_ROLE_NAME VARCHAR2 (240)
Name of the source role
ORG_ID NUMBER (15)
Organization ID
ORG_NAME VARCHAR2 (4000)
Organization name
JOB_TITLE VARCHAR2 (240)
Job title
PHONE_NUMBER VARCHAR2 (2000)
Phone number
EMAIL_ADDRESS VARCHAR2 (2000)
Email address
OWNER_FLAG VARCHAR2 (1)
OWNER_FLAG
Query Text

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


SELECT REQUEST_ID
,      RESOURCE_ID
,      RESOURCE_NAME
,      PROJECT_ROLE_ID
,      PROJECT_ROLE_NAME
,      SOURCE_ROLE_CODE
,      SOURCE_ROLE_NAME
,      ORG_ID
,      ORG_NAME
,      JOB_TITLE
,      PHONE_NUMBER
,      EMAIL_ADDRESS
,      OWNER_FLAG
FROM APPS.PA_PROJ_REQUEST_DIRECTORY_V;

Dependencies

[top of page]

APPS.PA_PROJ_REQUEST_DIRECTORY_V references the following:

SchemaAPPS
ViewAS_ACCESSES_ALL
ViewAS_LOOKUPS
PL/SQL PackageFND_ACCESS_CONTROL_UTIL - show dependent code
SynonymJTF_RS_RESOURCE_EXTNS
SynonymPA_OBJECT_RELATIONSHIPS
SynonymPA_PROJECT_REQUESTS
SynonymPA_VALUE_MAPS
SynonymPA_VALUE_MAP_DEFS
APPS.PA_PROJ_REQUEST_DIRECTORY_V is referenced by following:

SchemaAPPS
Package BodyPA_PROJECT_REQUEST_PVT - show dependent code