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_BILLING_EXTN_PARAMS_V

Object Details

Object Name:	PA_BILLING_EXTN_PARAMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_BILLING_EXTN_PARAMS_V
Subobject Name:
Status:	VALID

View Type

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

View of events for a MCB for a specific bill assignment id for use with billing extensions.
Full Description: is a runtime view for use in billing extensions that shows a single row with all the new conversion attributes and can be used if the user wants to create multi currency events from their extensions corresponding specific to the billing assignment id of the current run.

[View Source]

Columns

Name	Datatype	Length	Comments
BILLING_ASSIGNMENT_ID	NUMBER	(15)	The identifier of the billing assignment to which the event is assigned.
RATE_OVERRIDE_CURRENCY_CODE	VARCHAR2	(15)	Bill Rate Override Currency Code.
PROJECT_CURRENCY_CODE	VARCHAR2	(15)	Project Currency Code
PROJECT_RATE_TYPE	VARCHAR2	(30)	Exchange rate type to use for conversion between bill transaction currency to Project Currency for customer billing.
PROJECT_RATE_DATE	DATE		Exchange rate date to use for conversion between bill transaction currency to project currency if Fixed Date rate date type used for customer billing.
PROJECT_EXCHANGE_RATE	NUMBER		Exchange rate to be used for conversion between bill transaction currency to project currency if User exchange rate type used.
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)	Project Functional Currency
PROJFUNC_RATE_TYPE	VARCHAR2	(30)	Exchange rate type to use for conversion between bill transaction currency to project functional currency for customer billing.
PROJFUNC_RATE_DATE	DATE		Exchange rate date to use for conversion between bill transaction currency to project functional currency if Fixed Date rate date type used for customer billing.
PROJFUNC_EXCHANGE_RATE	NUMBER		Exchange rate to be used for conversion between bill transaction currency to project functional if User exchange rate type used.
FUNDING_RATE_TYPE	VARCHAR2	(30)	Exchange rate type to use for conversion between bill transaction currency to funding currency for customer billing.
FUNDING_RATE_DATE	DATE		Exchange rate date to use for conversion between bill transaction currency to funding currency if Fixed Date rate date type used for customer billing.
FUNDING_EXCHANGE_RATE	NUMBER		Exchange rate to be used for conversion between bill transaction currency to project or functional currency if User exchange rate type used.
DEFAULT_COST_PLAN_TYPE_ID	NUMBER	(15)	Unique Identifier of the plan type for cost budget
DEFAULT_REV_PLAN_TYPE_ID	NUMBER	(15)	Unique Identifier of the plan type for revenue budget

Query Text

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


SELECT BILLING_ASSIGNMENT_ID
,      RATE_OVERRIDE_CURRENCY_CODE
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE
,      PROJECT_EXCHANGE_RATE
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_RATE_DATE
,      PROJFUNC_EXCHANGE_RATE
,      FUNDING_RATE_TYPE
,      FUNDING_RATE_DATE
,      FUNDING_EXCHANGE_RATE
,      DEFAULT_COST_PLAN_TYPE_ID
,      DEFAULT_REV_PLAN_TYPE_ID
FROM APPS.PA_BILLING_EXTN_PARAMS_V;

Dependencies

[top of page]

APPS.PA_BILLING_EXTN_PARAMS_V references the following:

APPS: PA_BILLING - show dependent code; PA_BILLING_ASSIGNMENTS; PA_BILLING_EXTENSIONS; PA_PROJECTS_ALL

APPS.PA_BILLING_EXTN_PARAMS_V is referenced by following:

APPS: PA_BILLING - show dependent code; PA_BILL_PCT - show dependent code; PA_REV_CA - show dependent code