[Home] [Help] [Dependency Information]
Object Name: | PAXINGEN_PA_PROJ_SUM_TEMP |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PAXINGEN_PA_PROJ_SUM_TEMP |
Subobject Name: | |
Status: | VALID |
The PAAPIMPR_RCV_SUB_SUM_TEMP temporary table is used by the report of Interface Supplier Costs process.
PA.PAXINGEN_PA_PROJ_SUM_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | (15) | This is the Organization id of the project. | |
ORGANIZATION_NAME | VARCHAR2 | (240) | This is the Organization name of the project. | |
MEMBER_PERSON_ID | NUMBER | (15) | This is the person id of the member of the project. | |
MEMBER_NAME | VARCHAR2 | (240) | This is the member_name of the project. | |
PROJECT_ROLE_TYPE | VARCHAR2 | (20) | This is the project_role_type of the member of the project. | |
PROJECT_ROLE | VARCHAR2 | (80) | This is the project_role of the member of the project | |
PROJECT_ID | NUMBER | (15) | This is the project_id of the project. | |
PROJECT_NUMBER | VARCHAR2 | (25) | This is the Organization id. | |
PROJECT_NAME | VARCHAR2 | (30) | This is the project_number of the project. | |
DESCRIPTION | VARCHAR2 | (250) | This is the description of the project. | |
BUDGET_REVENUE_AMOUNT | NUMBER | This is the budget revenue amount for the project. | ||
TOTAL_REVENUE_AMOUNT | NUMBER | This is the total revenue amount for the project. | ||
WRITE_OFF_REVENUE_AMOUNT | NUMBER | This is the write_off revenue amount for the project. | ||
WRITE_ON_REVENUE_AMOUNT | NUMBER | This is the write_on revenue amount for the project. | ||
INVOICED_AMOUNT | NUMBER | This is the invoiced amount for the project. | ||
TOTAL_RETENTION_AMOUNT | NUMBER | This is the total retention amount for the project. | ||
RETENTION_BILLED_AMOUNT | NUMBER | This is the retention billed amount amount for the project. | ||
TOTAL_INVOICE_AMOUNT | NUMBER | This is the total invoice amount for the project. | ||
PROJFUNC_INVOICE_AMOUNT | NUMBER | This is the invoice amount for the project in functional currency. | ||
PROJFUNC_TOT_RETN_AMOUNT | NUMBER | This is the total retention amount for the project in functional currency. | ||
PROJFUNC_RETN_BILLED_AMOUNT | NUMBER | This is the retention billed amount for the project in functional currency. | ||
PROJFUNC_TOT_INV_AMOUNT | NUMBER | This is the total invoice amount for the project in functional currency. | ||
ON_HOLD_AMOUNT | NUMBER | This is the on hold amount for the project. | ||
ON_HOLD_QUANTITY | NUMBER | This is the on_hold_quantity for the project. | ||
INVOICE_LESS_WRITEOFF | NUMBER | This is the invoice less write off amount for the project. | ||
INVOICE_WRITEOFF | NUMBER | This is the invoice writeoff amount for the project. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, ORGANIZATION_NAME
, MEMBER_PERSON_ID
, MEMBER_NAME
, PROJECT_ROLE_TYPE
, PROJECT_ROLE
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, DESCRIPTION
, BUDGET_REVENUE_AMOUNT
, TOTAL_REVENUE_AMOUNT
, WRITE_OFF_REVENUE_AMOUNT
, WRITE_ON_REVENUE_AMOUNT
, INVOICED_AMOUNT
, TOTAL_RETENTION_AMOUNT
, RETENTION_BILLED_AMOUNT
, TOTAL_INVOICE_AMOUNT
, PROJFUNC_INVOICE_AMOUNT
, PROJFUNC_TOT_RETN_AMOUNT
, PROJFUNC_RETN_BILLED_AMOUNT
, PROJFUNC_TOT_INV_AMOUNT
, ON_HOLD_AMOUNT
, ON_HOLD_QUANTITY
, INVOICE_LESS_WRITEOFF
, INVOICE_WRITEOFF
FROM PA.PAXINGEN_PA_PROJ_SUM_TEMP;
PA.PAXINGEN_PA_PROJ_SUM_TEMP does not reference any database object
PA.PAXINGEN_PA_PROJ_SUM_TEMP is referenced by following:
|
|
|