[Home] [Help] [Dependency Information]
Object Name: | PA_PROJ_BILLING_STATUS_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_PROJ_BILLING_STATUS_VIEW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.PA_PROJ_BILLING_STATUS_VIEW is not referenced by any database object
|
|
|