eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_PROJECT_REQUESTS_V

Object Details

Object Name:	PA_PROJECT_REQUESTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJECT_REQUESTS_V
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

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
REQUEST_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the project request
REQUEST_NAME	VARCHAR2	(30)	Yes	User-defined name that uniquely identifies the project request.
REQUEST_NUMBER	VARCHAR2	(25)	Yes	The project request number that uniquely identifies the project request. The project request number can be user-defined or system-generated as defined i n the implementation options. (Note: in Phase 1, only system-generated project n umber is allowed.
REQUEST_TYPE	VARCHAR2	(80)	Yes	The request type that classifies the project request.
REQUEST_STATUS_NAME	VARCHAR2	(80)	Yes	The name of the request status.
REQUEST_SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	The request system status code.
DESCRIPTION	VARCHAR2	(250)		The description of the project request.
EXPECTED_PROJECT_APPROVAL_DATE	DATE			Expected approval date of the proposed project.
CLOSED_DATE	DATE			The date that the project request was closed by changing the request stat us to CLOSED
SOURCE_NAME	VARCHAR2	(240)		Source application name for the project request.
SOURCE_REFERENCE	VARCHAR2	(25)		The identifier in the external project management system from which the p roject request was created.
VALUE	NUMBER	(15)		Monetary value of the proposed project.
CURRENCY_CODE	VARCHAR2	(15)		Currency code for the proposed project.
PARTY_NAME	VARCHAR2	(360)		The name of project request customer.
PARTY_NUMBER	VARCHAR2	(30)		The number of project request customer.
ADDRESS1	VARCHAR2	(240)		The address of project request customer.
ADDRESS2	VARCHAR2	(240)		The address of project request customer.
ADDRESS3	VARCHAR2	(240)		The address of project request customer.
ADDRESS4	VARCHAR2	(240)		The address of project request customer.
CITY	VARCHAR2	(60)		The city in which the project request customer is located.
COUNTY	VARCHAR2	(60)		The county in which the project request customer is located.
STATE	VARCHAR2	(60)		The state in which the project request customer is located.
PROVINCE	VARCHAR2	(60)		The province in which the project request customer is located.
COUNTRY	VARCHAR2	(60)		The country in which the project request customer is located.
POSTAL_CODE	VARCHAR2	(60)		The postal_code in which the project request customer is located.
ADDRESS_LINES_PHONETIC	VARCHAR2	(560)		Phonetic or Kana representation of the Kanji address lines (used in Japan).
CUSTOMER_NUMBER	VARCHAR2	(30)		The account number of the the project request customer.
ACCOUNT_NAME	VARCHAR2	(240)		The account name of the the project request customer.
SOURCE_ORGANIZATION	VARCHAR2	(4000)		The name of the organization in the external project management system from which the project request was created.
RECORD_VERSION_NUMBER	NUMBER	(15)	Yes	Indicates the version of the project request record. The column increments by one upon each saved modification to the project request record.

Query Text

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


SELECT ROW_ID
,      REQUEST_ID
,      REQUEST_NAME
,      REQUEST_NUMBER
,      REQUEST_TYPE
,      REQUEST_STATUS_NAME
,      REQUEST_SYSTEM_STATUS_CODE
,      DESCRIPTION
,      EXPECTED_PROJECT_APPROVAL_DATE
,      CLOSED_DATE
,      SOURCE_NAME
,      SOURCE_REFERENCE
,      VALUE
,      CURRENCY_CODE
,      PARTY_NAME
,      PARTY_NUMBER
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      COUNTY
,      STATE
,      PROVINCE
,      COUNTRY
,      POSTAL_CODE
,      ADDRESS_LINES_PHONETIC
,      CUSTOMER_NUMBER
,      ACCOUNT_NAME
,      SOURCE_ORGANIZATION
,      RECORD_VERSION_NUMBER
FROM APPS.PA_PROJECT_REQUESTS_V;

Dependencies

[top of page]

APPS.PA_PROJECT_REQUESTS_V references the following:

APPS: FND_ACCESS_CONTROL_UTIL - show dependent code; FND_APPLICATION_TL; HZ_CUST_ACCOUNTS; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; PA_LOOKUPS; PA_PROJECT_REQUESTS; PA_PROJECT_STATUSES

APPS.PA_PROJECT_REQUESTS_V is not referenced by any database object