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: ViewPA.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:

SchemaAPPS
PL/SQL PackagePA_BILLING - show dependent code
SynonymPA_DRAFT_INVOICES
SynonymPA_DRAFT_INVOICE_ITEMS
SynonymPA_EVENTS
APPS.PA_BILLING_ORIG_EVENTS_V is referenced by following:

SchemaAPPS
Package BodyMYPACKAGENAME - show dependent code