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

TABLE: PA.PA_SUMMARY_PROJECT_RETN

Object Details
Object Name: PA_SUMMARY_PROJECT_RETN
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_SUMMARY_PROJECT_RETN
Subobject Name:
Status: VALID


PA_SUMMARY_PROJECT_RETN stores summary retention amounts calculated based on retention and retention billing setup at the project or top task level. These amounts are the summary amounts of the detailed retention records. These amounts are maintained during the regular invoice process (for unbilled retention) and the retention invoice process (for billed retention).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_SUMMARY_PROJECT_RETN_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnTASK_ID
ColumnAGREEMENT_ID
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes The identifier of the project to which retention is retained
TASK_ID NUMBER (15)
The identifier of the task to which retention is retained
AGREEMENT_ID NUMBER (15) Yes The identifier of the agreement to which retention is retained
CUSTOMER_ID NUMBER (15) Yes The identifier of the customer to which retention ins 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
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
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
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 invoice. This amount is in the funding currency
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who Column
PROGRAM_ID NUMBER (15)
Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
REQUEST_ID NUMBER (15)
Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      AGREEMENT_ID
,      CUSTOMER_ID
,      INVPROC_CURRENCY_CODE
,      TOTAL_RETAINED
,      TOTAL_BILLED
,      TOTAL_WRITEOFF
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_TOTAL_RETAINED
,      PROJFUNC_TOTAL_BILLED
,      PROJFUNC_TOTAL_WRITEOFF
,      PROJECT_CURRENCY_CODE
,      PROJECT_TOTAL_RETAINED
,      PROJECT_TOTAL_BILLED
,      PROJECT_TOTAL_WRITEOFF
,      FUNDING_CURRENCY_CODE
,      FUNDING_TOTAL_RETAINED
,      FUNDING_TOTAL_BILLED
,      FUNDING_TOTAL_WRITEOFF
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_SUMMARY_PROJECT_RETN;

Dependencies

[top of page]

PA.PA_SUMMARY_PROJECT_RETN does not reference any database object

PA.PA_SUMMARY_PROJECT_RETN is referenced by following:

SchemaPA
ViewPA_SUMMARY_PROJECT_RETN#