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_BILLING_DETAIL_VIEW

Object Details

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

View Type

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

PA_PROJ_BILLING_DETAIL_VIEW is a base view used to report the billing
status of projects. A base view is a view on which other views
are built. We recommend that you do not use base views for
reporting and online query. Instead, you can more easily use the
views which are built upon the base views.
.
.
You can use the PA_PROJ_BILLING_STATUS_VIEW view which is built upon
this view, to report the billing status of projects.

[View Source]

Columns

Name	Datatype	Length	Comments
BILLING_METHOD	VARCHAR2	(5)	The billing method at the project level
PROJECT_ID	NUMBER	(15)	The identifier of the project
PROJECT_NUMBER	VARCHAR2	(25)	Number of the project
PROJECT_NAME	VARCHAR2	(30)	Name of the project
RETN_ACCOUNTING_FLAG	VARCHAR2	(1)	Retention Accounting Flag of the project
LAST_RELEASED_INVOICE_NUM	VARCHAR2	(40)	Draft invoice number of the last released invoice that is not a crediting i nvoice. This column is blank if the project has never been invoiced
LAST_RELEASED_INVOICE_DATE	VARCHAR2	(9)	Invoice date of the last released invoice that is not a crediting invoice. This column is blank if the project has never been invoiced
LAST_RELEASED_BILL_THRU_DATE	VARCHAR2	(9)	Bill through date of the last released invoice that is not a crediting invo ice. This column is blank if the project has never been invoiced
DAYS_SINCE_LAST_RELEASE	NUMBER		Number of days since the last released invoice"s invoice date. This column is blank if the project has never been invoiced
NEXT_BILLING_DATE	VARCHAR2	(9)	Next billing date based on the billing cycle and bill offset for projects u sing WORK billing
NEXT_EVENT_AMOUNT	NUMBER		Amount of the next billing event for projects using EVENT billing
PENDING_INVOICE_AMOUNT	NUMBER		Total unreleased invoice amount for the project
REVENUE_AMOUNT	NUMBER		Total project revenue amount (regardless of revenue status)
INVOICE_AMOUNT	NUMBER		Total released invoice amount for the project
NEXT_EVENT_PROJFUNC_AMOUNT	NUMBER		Amount of the next billing event for projects using EVENT billing in project functional currency
PENDING_PROJFUNC_INV_AMOUNT	NUMBER		Total unreleased invoice amount for the project in project functional currency
PROJFUNC_REVENUE_AMOUNT	NUMBER		Total project revenue amount (regardless of revenue status) in project functional currency
PROJFUNC_INVOICE_AMOUNT	NUMBER		Total released invoice amount for the project in project functional currency
PROJFUNC_TOTAL_INVOICED_AMOUNT	NUMBER		Total released invoice amount (excluding Retention and Write-offs) for the project in project functional currency
PROJFUNC_UNBILLED_RETENTION	NUMBER		Total Unbilled Retention invoice amount for the project in project functional currency
ENABLE_TOP_TASK_INV_MTH_FLAG	VARCHAR2	(1)	Indicates if invoice method can be associated at the top task level
EVENT_ID	NUMBER		EventId

Query Text

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


SELECT BILLING_METHOD
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      RETN_ACCOUNTING_FLAG
,      LAST_RELEASED_INVOICE_NUM
,      LAST_RELEASED_INVOICE_DATE
,      LAST_RELEASED_BILL_THRU_DATE
,      DAYS_SINCE_LAST_RELEASE
,      NEXT_BILLING_DATE
,      NEXT_EVENT_AMOUNT
,      PENDING_INVOICE_AMOUNT
,      REVENUE_AMOUNT
,      INVOICE_AMOUNT
,      NEXT_EVENT_PROJFUNC_AMOUNT
,      PENDING_PROJFUNC_INV_AMOUNT
,      PROJFUNC_REVENUE_AMOUNT
,      PROJFUNC_INVOICE_AMOUNT
,      PROJFUNC_TOTAL_INVOICED_AMOUNT
,      PROJFUNC_UNBILLED_RETENTION
,      ENABLE_TOP_TASK_INV_MTH_FLAG
,      EVENT_ID
FROM APPS.PA_PROJ_BILLING_DETAIL_VIEW;

Dependencies

[top of page]

APPS.PA_PROJ_BILLING_DETAIL_VIEW references the following:

APPS: PA_BILLING_CYCLES_PKG - show dependent code; PA_DRAFT_INVOICES; PA_DRAFT_INVOICE_ITEMS; PA_DRAFT_REVENUES; PA_DRAFT_REVENUE_ITEMS; PA_EVENTS; PA_PROJECTS; PA_PROJECTS_ALL; PA_PROJECT_TYPES_ALL; PA_PROJECT_UTILS - show dependent code

APPS.PA_PROJ_BILLING_DETAIL_VIEW is referenced by following:

APPS: PA_PROJ_BILLING_STATUS_VIEW