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_INV_TRANSACTIONS_V

Object Details

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

View Type

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

PA_BILLING_INV_TRANSACTIONS_V returns detail information for amounts processed in the current run of invoice generation. When this view is used in a billing extension, the rows returned are limited automatically to the rows for that request_id, for that project/task and the appropriate calling place (regular vs adjustment).
.
This view should be used in a transaction-dependent billing extension that is being called in both regular and adjustment processing during invoice generation.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	Identifier of the project
TASK_ID	NUMBER	(15)	Yes	Identifier of the task
TOP_TASK_ID	NUMBER	(15)	Yes	Identifier of the top task to which this tasks rolls up
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Classifies the type of work performed
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)	Yes	Classification of the expenditure group that indicates what type of charges are entered for the group
EXPENDITURE_ID	NUMBER	(15)	Yes	Identifier of the expenditure
INCURRED_BY_PERSON_ID	NUMBER	(15)		Identifier of the employee who incurred the charges
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes	Identifier of the expenditure item
EXPENDITURE_ITEM_DATE	DATE		Yes	Date on which work occured.
QUANTITY	NUMBER			Number of units of the work performed
RAW_COST	NUMBER			Total raw cost of the expenditure item
BURDENED_COST	NUMBER			Total burdened cost of the expenditure item.
BILL_AMOUNT	NUMBER			Amount billed for the item.
REVENUE_AMOUNT	NUMBER			Revenue amount of the expenditure item.
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		Project functional currency code

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      TOP_TASK_ID
,      EXPENDITURE_TYPE
,      SYSTEM_LINKAGE_FUNCTION
,      EXPENDITURE_ID
,      INCURRED_BY_PERSON_ID
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ITEM_DATE
,      QUANTITY
,      RAW_COST
,      BURDENED_COST
,      BILL_AMOUNT
,      REVENUE_AMOUNT
,      PROJECT_CURRENCY_CODE
FROM APPS.PA_BILLING_INV_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.PA_BILLING_INV_TRANSACTIONS_V references the following:

APPS: PA_BILLING - show dependent code; PA_CUST_REV_DIST_LINES_ALL; PA_DRAFT_INVOICES; PA_DRAFT_INVOICE_ITEMS; PA_EXPENDITURES_ALL; PA_EXPENDITURE_ITEMS_ALL; PA_TASKS

APPS.PA_BILLING_INV_TRANSACTIONS_V is referenced by following:

APPS: MYPACKAGENAME - show dependent code