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_PROJ_FUND_VALID_V

Object Details

Object Name:	PA_PROJ_FUND_VALID_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJ_FUND_VALID_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	Comments
PROJECT_ID	NUMBER	(15)	- ID of the project
NAME	VARCHAR2	(30)	- project name
SEGMENT1	VARCHAR2	(25)	- project number
CUSTOMER_ID	NUMBER	(15)	- ID of the customer
ALLOWABLE_FUNDING_LEVEL_CODE	VARCHAR2	(30)	- Code indicating if project/task/both level of funding is allowed
MEANING	VARCHAR2	(80)	- Description of ccde indicating if project/task/both level of funding is allowed
PROJECT_TYPE_CLASS_CODE	VARCHAR2	(30)	- Code indicating the class of the project type
CUSTOMER_BILL_SPLIT	NUMBER	(7)	- The percentage of the total project revenue and invoice that the customer is charged
TEMPLATE_FLAG	VARCHAR2	(1)	- Flag indicating if the project is template of not
MULTI_CURRENCY_BILLING_FLAG	VARCHAR2	(1)	- Flag indicating if multi-currency billing is allowed for this project
INVPROC_CURRENCY_TYPE	VARCHAR2	(30)	- Invoice processing currency type of the project
REVPROC_CURRENCY_CODE	VARCHAR2	(15)	- Revenue processing currency code of the project
PROJECT_CURRENCY_CODE	VARCHAR2	(15)	- Project currency code of the project
PROJECT_BIL_RATE_DATE_CODE	VARCHAR2	(30)	- Exchange rate date type for determining the date to use for conversion from bill transaction currency/ funding currency to project currency for customer billing.
PROJECT_BIL_RATE_TYPE	VARCHAR2	(30)	- Exchange rate type to use for conversion from bill transaction currency/ funding currency to project currency for customer billing
PROJECT_BIL_RATE_TYPE_NAME	VARCHAR2	(30)	- Exchange rate type name to use for conversion from bill transaction currency/ funding currency to project currency for customer billing
PROJECT_BIL_RATE_DATE	DATE		- Exchange rate date to use for conversion from bill transaction currency/ funding currency to project currency if Fixed Date rate date type is used for customer billing.
PROJECT_BIL_EXCHANGE_RATE	NUMBER		- Exchange rate to use for conversion from bill transaction currency/ funding currency to project currency if User exchange rate type is used
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)	- Project functional currency code of the project
PROJFUNC_BIL_RATE_DATE_CODE	VARCHAR2	(30)	- Exchange rate date type for determining the date to use for conversion from bill transaction currency/ funding currency to project functional currency for customer billing.
PROJFUNC_BIL_RATE_TYPE	VARCHAR2	(30)	- Exchange rate type to use for conversion from bill transaction currency/ funding currency to project functional currency for customer billing
PROJFUNC_BIL_RATE_TYPE_NAME	VARCHAR2	(30)	- Exchange rate type name to use for conversion from bill transaction currency/ funding currency to project functional currency for customer billing
PROJFUNC_BIL_RATE_DATE	DATE		- Exchange rate date to use for conversion from bill transaction currency/ funding currency to project functional currency if Fixed Date rate date type is used for customer billing.
PROJFUNC_BIL_EXCHANGE_RATE	NUMBER		- Exchange rate to use for conversion from bill transaction currency/ funding currency to project functional currency if User exchange rate type is used
ENABLE_TOP_TASK_CUSTOMER_FLAG	VARCHAR2	(1)	- Enable Top Task Customer Flag
ORG_ID	NUMBER	(15)	- Org ID of the Project
CC_PRVDR_FLAG	VARCHAR2	(1)	- Flag to Check for the cross charge projects

Query Text

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


SELECT PROJECT_ID
,      NAME
,      SEGMENT1
,      CUSTOMER_ID
,      ALLOWABLE_FUNDING_LEVEL_CODE
,      MEANING
,      PROJECT_TYPE_CLASS_CODE
,      CUSTOMER_BILL_SPLIT
,      TEMPLATE_FLAG
,      MULTI_CURRENCY_BILLING_FLAG
,      INVPROC_CURRENCY_TYPE
,      REVPROC_CURRENCY_CODE
,      PROJECT_CURRENCY_CODE
,      PROJECT_BIL_RATE_DATE_CODE
,      PROJECT_BIL_RATE_TYPE
,      PROJECT_BIL_RATE_TYPE_NAME
,      PROJECT_BIL_RATE_DATE
,      PROJECT_BIL_EXCHANGE_RATE
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_BIL_RATE_DATE_CODE
,      PROJFUNC_BIL_RATE_TYPE
,      PROJFUNC_BIL_RATE_TYPE_NAME
,      PROJFUNC_BIL_RATE_DATE
,      PROJFUNC_BIL_EXCHANGE_RATE
,      ENABLE_TOP_TASK_CUSTOMER_FLAG
,      ORG_ID
,      CC_PRVDR_FLAG
FROM APPS.PA_PROJ_FUND_VALID_V;

Dependencies

[top of page]

APPS.PA_PROJ_FUND_VALID_V references the following:

APPS: PA_CONVERSION_TYPES_V; PA_LOOKUPS; PA_MULTI_CURRENCY_BILLING - show dependent code; PA_PROJECTS; PA_PROJECTS_ALL; PA_PROJECT_CUSTOMERS; PA_PROJECT_STUS_UTILS - show dependent code; PA_PROJECT_TYPES; PA_PROJECT_TYPES_ALL; PA_SECURITY - show dependent code

APPS.PA_PROJ_FUND_VALID_V is referenced by following:

APPS: PA_FUNDING_CORE - show dependent code