[Home] [Help]
[Dependency Information]
Object Name: | PA_SUMMARY_PROJECT_RETNS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Oracle RowId | |
PROJECT_ID | NUMBER | (15) | Yes | The identifier of the project to which retention is retained |
PROJECT_NUMBER | VARCHAR2 | (25) | Number of the project to which retention is retained | |
PROJECT_NAME | VARCHAR2 | (30) | Name of the project to which retention is retained | |
TASK_ID | NUMBER | (15) | The identifier of the task to which retention is retained | |
TASK_NUMBER | VARCHAR2 | (25) | Number of the task to which retention is retained | |
TASK_NAME | VARCHAR2 | (20) | Name of the task to which retention is retained | |
AGREEMENT_ID | NUMBER | (15) | Yes | The identifier of the agreement to which retention is retained |
AGREEMENT_NUM | VARCHAR2 | (50) | Yes | Number of the agreement to which retention is retained |
CUSTOMER_ID | NUMBER | (15) | Yes | The identifier of the customer to which retention is retained |
RETENTION_LEVEL_NAME | VARCHAR2 | (80) | Retention level name indicates the level name of the retention setup | |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Yes | Number of the customer to which retention is retained |
CUSTOMER_NAME | VARCHAR2 | (50) | Name of the customer to which retention is retained | |
INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | Yes | The identifier of the invoice processing currency |
TOTAL_RETAINED | NUMBER | Total retained amount for a project or top task based on the retention billing rule. This amount is in the invoice processing currency | ||
TOTAL_BILLED | NUMBER | Total billed amount for a project or top task based on the retention billing rule. This amount is in the invoice processing currency | ||
TOTAL_WRITEOFF | NUMBER | Total write-off amount on retention invoices. This amount is in the invoice processing currency | ||
FUNDING_CURRENCY_CODE | VARCHAR2 | (15) | Yes | The identifier of the funding currency |
FUNDING_TOTAL_RETAINED | NUMBER | Total retained amount for a project or top task based on the retention billing rule. This amount is in the funding currency | ||
FUNDING_TOTAL_BILLED | NUMBER | Total billed amount for a project or top task based on the retention billing rule. This amount is in the funding currency | ||
FUNDING_TOTAL_WRITEOFF | NUMBER | Total write-off amount on retention invoices. This amount is in the funding currency | ||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | The identifier of the project currency |
PROJECT_TOTAL_RETAINED | NUMBER | Total retained amount for a project or top task based on the retention billing rule. This amount is in the project currency | ||
PROJECT_TOTAL_BILLED | NUMBER | Total billed amount for a project or top task based on the retention billing rule. This amount is in the project currency | ||
PROJECT_TOTAL_WRITEOFF | NUMBER | Total write-off amount on retention invoices. This amount is in the project currency | ||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | Yes | The identifier of the project functional currency |
PROJFUNC_TOTAL_RETAINED | NUMBER | Total retained amount for a project or top task based on the retention billing rule. This amount is in the project functional currency | ||
PROJFUNC_TOTAL_BILLED | NUMBER | Total billed amount for a project or top task based on the retention billing rule. This amount is in the project functional currency | ||
PROJFUNC_TOTAL_WRITEOFF | NUMBER | Total write-off amount on retention invoices. This amount is in the project functional currency |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, AGREEMENT_ID
, AGREEMENT_NUM
, CUSTOMER_ID
, RETENTION_LEVEL_NAME
, CUSTOMER_NUMBER
, CUSTOMER_NAME
, INVPROC_CURRENCY_CODE
, TOTAL_RETAINED
, TOTAL_BILLED
, TOTAL_WRITEOFF
, FUNDING_CURRENCY_CODE
, FUNDING_TOTAL_RETAINED
, FUNDING_TOTAL_BILLED
, FUNDING_TOTAL_WRITEOFF
, PROJECT_CURRENCY_CODE
, PROJECT_TOTAL_RETAINED
, PROJECT_TOTAL_BILLED
, PROJECT_TOTAL_WRITEOFF
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_TOTAL_RETAINED
, PROJFUNC_TOTAL_BILLED
, PROJFUNC_TOTAL_WRITEOFF
FROM APPS.PA_SUMMARY_PROJECT_RETNS_V;
APPS.PA_SUMMARY_PROJECT_RETNS_V is not referenced by any database object
|
|
|