DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_PROJ_BILLING_STATUS_VIEW

Object Details
Object Name: PA_PROJ_BILLING_STATUS_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_PROJ_BILLING_STATUS_VIEW
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
BILLING_METHOD VARCHAR2 (5)
The billing method of the project: the value is either EVENT or WORK
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 invoice. 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 invoice. 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 using 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
UNBILLED_RECEIVABLE_AMOUNT NUMBER

Project unbilled receivables defined as (total project revenue amount - total released invoice amount)
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_UBR_AMOUNT NUMBER

Project unbilled receivables defined as (total project revenue amount - total released invoice amount) 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

Id of Event
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
,      UNBILLED_RECEIVABLE_AMOUNT
,      NEXT_EVENT_PROJFUNC_AMOUNT
,      PENDING_PROJFUNC_INV_AMOUNT
,      PROJFUNC_REVENUE_AMOUNT
,      PROJFUNC_INVOICE_AMOUNT
,      PROJFUNC_UBR_AMOUNT
,      PROJFUNC_UNBILLED_RETENTION
,      ENABLE_TOP_TASK_INV_MTH_FLAG
,      EVENT_ID
FROM APPS.PA_PROJ_BILLING_STATUS_VIEW;

Dependencies

[top of page]

APPS.PA_PROJ_BILLING_STATUS_VIEW references the following:

SchemaAPPS
PL/SQL PackagePA_BILLING_CYCLES_PKG - show dependent code
PL/SQL PackagePA_PROJECT_UTILS - show dependent code
ViewPA_PROJ_BILLING_DETAIL_VIEW

APPS.PA_PROJ_BILLING_STATUS_VIEW is not referenced by any database object