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

TABLE: PA.PAXINGEN_PA_PROJ_SUM_TEMP

Object Details
Object Name: PAXINGEN_PA_PROJ_SUM_TEMP
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.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.

Temporary Table Details

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.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
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.
Query Text

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;

Dependencies

[top of page]

PA.PAXINGEN_PA_PROJ_SUM_TEMP does not reference any database object

PA.PAXINGEN_PA_PROJ_SUM_TEMP is referenced by following:

SchemaAPPS
SynonymPAXINGEN_PA_PROJ_SUM_TEMP