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_ORIG_EVENTS_V

Object Details

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

View Type

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

PA_BILLING_ORIG_EVENTS_V is a runtime view for use in billing
extensions that shows the original event information
for a credit memo automatic event for the specific project and top
task of the current run.
.
.
For more information, see the billing extension template
described in the Oracle Projects User's Guide.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project to which the event is assigned.
TASK_ID	NUMBER	(15)		The identifier of the top level task to which the event is assigned.
EVENT_NUM	NUMBER	(15)	Yes	The sequential number that identifies the event entered for a task
EVENT_TYPE	VARCHAR2	(30)	Yes	The event type that classifies the event
REVENUE_AMOUNT	NUMBER	(22)	Yes	The amount of revenue to accrue for the event upon the event's completion date
BILL_AMOUNT	NUMBER	(22)	Yes	The amount to be billed for the event on an invoice upon the event's completion date
BILLING_ASSIGNMENT_ID	NUMBER	(15)		The unique identifier of billing extension assignment that is basis for creating the automatic event.
ORGANIZATION_ID	NUMBER	(15)	Yes	The unique identifier of the organization for the event. For example, this may be used to credit revenue to different organization.
COMPLETION_DATE	DATE			The date on which the event is complete and on or after which the event is processed for revenue accrual and/or invoicing
BILL_TRANS_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency code of the event
BILL_TRANS_BILL_AMOUNT	NUMBER			Bill Amount in Event Transaction Currency
BILL_TRANS_REV_AMOUNT	NUMBER			Revenue Amount in Event Transaction Currency
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.
PROJECT_INV_RATE_DATE	DATE			Rate date is used during invoice generation
PROJECT_INV_EXCHANGE_RATE	NUMBER			Exchange Rate is used during invoice generation
PROJECT_BILL_AMOUNT	NUMBER			Bill amount in Project Currency. This will be calculated by applying the Project Currency setup conversion rules on the bill transaction base bill amount during invoice generation
PROJECT_REV_RATE_DATE	DATE			Rate date is used during revenue generation
PROJECT_REV_EXCHANGE_RATE	NUMBER			Exchange Rate is used during revenue generation
PROJECT_REVENUE_AMOUNT	NUMBER			Revenue Amount in Project Currency. This will be calculated by applying the Project Currency setup conversion rules on the bill transaction base revenue amount during revenue generation
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.
PROJFUNC_INV_RATE_DATE	DATE			Rate date is used during invoice generation
PROJFUNC_INV_EXCHANGE_RATE	NUMBER			Exchange Rate is used during invoice generation
PROJFUNC_BILL_AMOUNT	NUMBER			Bill amount in Project Functional Currency. This will be calculated by applying the Project Functional Currency setup conversion rules on the bill transaction base bill amount during invoice generation
PROJFUNC_REV_RATE_DATE	DATE			Rate date is used during revenue generation
PROJFUNC_REV_EXCHANGE_RATE	NUMBER			Exchange Rate is used during revenue generation
PROJFUNC_REVENUE_AMOUNT	NUMBER			Revenue amount in Project Functional. Revenue amount in project functional currency is calculated by applying the Project Functional Currency setup conversion rules on the bill transaction base revenue amount during invoice generation.
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
INVPROC_CURRENCY_CODE	VARCHAR2	(15)		Invoice Processing Currency
INVPROC_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion between bill transaction currency to invoice processing currency for customer billing.
INVPROC_RATE_DATE	DATE			Exchange rate date to use for conversion between bill transaction currency to invoice processing currency if Fixed Date rate date type used for customer billing.
INVPROC_EXCHANGE_RATE	NUMBER			Exchange rate to be used for conversion between bill transaction currency to invoice processing currency.
REVPROC_CURRENCY_CODE	VARCHAR2	(15)		Revenue Processing Currency
REVPROC_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion between bill transaction currency to revenue processing currency for customer billing.Currently revenue processing currency is project functional currency
REVPROC_RATE_DATE	DATE			Exchange rate date to use for conversion between bill transaction currency to revenue processing currency if Fixed Date rate date type used for customer billing
REVPROC_EXCHANGE_RATE	NUMBER			Exchange rate to be used for conversion between bill transaction currency to revenue processing currency
INV_GEN_REJECTION_CODE	VARCHAR2	(30)		Invoice generation rejection code

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      EVENT_NUM
,      EVENT_TYPE
,      REVENUE_AMOUNT
,      BILL_AMOUNT
,      BILLING_ASSIGNMENT_ID
,      ORGANIZATION_ID
,      COMPLETION_DATE
,      BILL_TRANS_CURRENCY_CODE
,      BILL_TRANS_BILL_AMOUNT
,      BILL_TRANS_REV_AMOUNT
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE
,      PROJECT_EXCHANGE_RATE
,      PROJECT_INV_RATE_DATE
,      PROJECT_INV_EXCHANGE_RATE
,      PROJECT_BILL_AMOUNT
,      PROJECT_REV_RATE_DATE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJECT_REVENUE_AMOUNT
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_RATE_DATE
,      PROJFUNC_EXCHANGE_RATE
,      PROJFUNC_INV_RATE_DATE
,      PROJFUNC_INV_EXCHANGE_RATE
,      PROJFUNC_BILL_AMOUNT
,      PROJFUNC_REV_RATE_DATE
,      PROJFUNC_REV_EXCHANGE_RATE
,      PROJFUNC_REVENUE_AMOUNT
,      FUNDING_RATE_TYPE
,      FUNDING_RATE_DATE
,      FUNDING_EXCHANGE_RATE
,      INVPROC_CURRENCY_CODE
,      INVPROC_RATE_TYPE
,      INVPROC_RATE_DATE
,      INVPROC_EXCHANGE_RATE
,      REVPROC_CURRENCY_CODE
,      REVPROC_RATE_TYPE
,      REVPROC_RATE_DATE
,      REVPROC_EXCHANGE_RATE
,      INV_GEN_REJECTION_CODE
FROM APPS.PA_BILLING_ORIG_EVENTS_V;

Dependencies

[top of page]

APPS.PA_BILLING_ORIG_EVENTS_V references the following:

APPS: PA_BILLING - show dependent code; PA_DRAFT_INVOICES; PA_DRAFT_INVOICE_ITEMS; PA_EVENTS

APPS.PA_BILLING_ORIG_EVENTS_V is referenced by following:

APPS: MYPACKAGENAME - show dependent code