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

TABLE: PA.PA_FP_WEBADI_XFACE_TMP

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

This global temporary table is used in Budgeting and Forecasting Microsoft Excel Integration during download of budgets and forecasts in periodic layouts.

Temporary Table Details

PA.PA_FP_WEBADI_XFACE_TMP 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$SESSION. 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
BUDGET_VERSION_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15)
RESOURCE_ASSIGNMENT_ID NUMBER (15)
RESOURCE_GROUP_NAME VARCHAR2 (240)
RESOURCE_ALIAS VARCHAR2 (240)
PROJECT_NAME VARCHAR2 (240)
TASK_NAME VARCHAR2 (240)
TASK_NUMBER VARCHAR2 (240)
AMOUNT_TYPE_NAME VARCHAR2 (240)
AMOUNT_SUBTYPE_NAME VARCHAR2 (240)
TXN_CURRENCY_CODE VARCHAR2 (15)
SUCCEEDING_PERIOD_AMOUNT NUMBER

PRECEDING_PERIOD_AMOUNT NUMBER

DELETE_FLAG VARCHAR2 (1)
PARENT_PERIODS VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

UNIT_OF_MEASURE VARCHAR2 (240)
DESCRIPTION VARCHAR2 (255)
CHANGE_REASON VARCHAR2 (240)
QUANTITY NUMBER

RAW_COST NUMBER

BURDENED_COST NUMBER

REVENUE NUMBER

PROJFUNC_COST_RATE_TYPE VARCHAR2 (240)
PROJFUNC_COST_RATE_DATE_TYPE VARCHAR2 (240)
PROJFUNC_COST_EXCHANGE_RATE NUMBER

PROJFUNC_COST_RATE_DATE DATE

PROJECT_COST_RATE_TYPE VARCHAR2 (240)
PROJECT_COST_RATE_DATE_TYPE VARCHAR2 (240)
PROJECT_COST_EXCHANGE_RATE NUMBER

PROJECT_COST_RATE_DATE DATE

PROJFUNC_REV_RATE_TYPE VARCHAR2 (240)
PROJFUNC_REV_RATE_DATE_TYPE VARCHAR2 (240)
PROJFUNC_REV_EXCHANGE_RATE NUMBER

PROJFUNC_REV_RATE_DATE DATE

PROJECT_REV_RATE_TYPE VARCHAR2 (240)
PROJECT_REV_RATE_DATE_TYPE VARCHAR2 (240)
PROJECT_REV_EXCHANGE_RATE NUMBER

PROJECT_REV_RATE_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
VAL_ERROR_FLAG VARCHAR2 (1)
VAL_ERROR_CODE VARCHAR2 (30)
PRD1 NUMBER

PRD2 NUMBER

PRD3 NUMBER

PRD4 NUMBER

PRD5 NUMBER

PRD6 NUMBER

PRD7 NUMBER

PRD8 NUMBER

PRD9 NUMBER

PRD10 NUMBER

PRD11 NUMBER

PRD12 NUMBER

PRD13 NUMBER

PRD14 NUMBER

PRD15 NUMBER

PRD16 NUMBER

PRD17 NUMBER

PRD18 NUMBER

PRD19 NUMBER

PRD20 NUMBER

PRD21 NUMBER

PRD22 NUMBER

PRD23 NUMBER

PRD24 NUMBER

PRD25 NUMBER

PRD26 NUMBER

PRD27 NUMBER

PRD28 NUMBER

PRD29 NUMBER

PRD30 NUMBER

PRD31 NUMBER

PRD32 NUMBER

PRD33 NUMBER

PRD34 NUMBER

PRD35 NUMBER

PRD36 NUMBER

PRD37 NUMBER

PRD38 NUMBER

PRD39 NUMBER

PRD40 NUMBER

PRD41 NUMBER

PRD42 NUMBER

PRD43 NUMBER

PRD44 NUMBER

PRD45 NUMBER

PRD46 NUMBER

PRD47 NUMBER

PRD48 NUMBER

PRD49 NUMBER

PRD50 NUMBER

PRD51 NUMBER

PRD52 NUMBER

RECORD_VERSION_NUMBER NUMBER

PROJFUNC_RATE_TYPE VARCHAR2 (240)
PROJFUNC_RATE_DATE_TYPE VARCHAR2 (240)
PROJFUNC_EXCHANGE_RATE NUMBER

PROJFUNC_RATE_DATE DATE

PROJECT_RATE_TYPE VARCHAR2 (240)
PROJECT_RATE_DATE_TYPE VARCHAR2 (240)
PROJECT_EXCHANGE_RATE NUMBER

PROJECT_RATE_DATE DATE

FIN_PLAN_PREFERENCE_CODE VARCHAR2 (30)
PLAN_CLASS_CODE VARCHAR2 (30)
PROJECT_NUMBER VARCHAR2 (25)
TASK_DISPLAY_SEQUENCE NUMBER (15)
RESOURCE_LIST_MEMBER_ID NUMBER (15)
AMOUNT_TYPE_CODE VARCHAR2 (30)
SPREAD_CURVE_ID NUMBER (15)
SPREAD_CURVE VARCHAR2 (240)
MFC_COST_TYPE_ID NUMBER (15)
MFC_COST_TYPE VARCHAR2 (10)
ETC_METHOD_CODE VARCHAR2 (30)
ETC_METHOD VARCHAR2 (80)
ETC_SOURCE VARCHAR2 (80)
PHYSICAL_PERCENT_COMPLETE NUMBER (15)
Query Text

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


SELECT BUDGET_VERSION_ID
,      PROJECT_ID
,      RESOURCE_ASSIGNMENT_ID
,      RESOURCE_GROUP_NAME
,      RESOURCE_ALIAS
,      PROJECT_NAME
,      TASK_NAME
,      TASK_NUMBER
,      AMOUNT_TYPE_NAME
,      AMOUNT_SUBTYPE_NAME
,      TXN_CURRENCY_CODE
,      SUCCEEDING_PERIOD_AMOUNT
,      PRECEDING_PERIOD_AMOUNT
,      DELETE_FLAG
,      PARENT_PERIODS
,      START_DATE
,      END_DATE
,      UNIT_OF_MEASURE
,      DESCRIPTION
,      CHANGE_REASON
,      QUANTITY
,      RAW_COST
,      BURDENED_COST
,      REVENUE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_RATE_DATE_TYPE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJFUNC_COST_RATE_DATE
,      PROJECT_COST_RATE_TYPE
,      PROJECT_COST_RATE_DATE_TYPE
,      PROJECT_COST_EXCHANGE_RATE
,      PROJECT_COST_RATE_DATE
,      PROJFUNC_REV_RATE_TYPE
,      PROJFUNC_REV_RATE_DATE_TYPE
,      PROJFUNC_REV_EXCHANGE_RATE
,      PROJFUNC_REV_RATE_DATE
,      PROJECT_REV_RATE_TYPE
,      PROJECT_REV_RATE_DATE_TYPE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJECT_REV_RATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VAL_ERROR_FLAG
,      VAL_ERROR_CODE
,      PRD1
,      PRD2
,      PRD3
,      PRD4
,      PRD5
,      PRD6
,      PRD7
,      PRD8
,      PRD9
,      PRD10
,      PRD11
,      PRD12
,      PRD13
,      PRD14
,      PRD15
,      PRD16
,      PRD17
,      PRD18
,      PRD19
,      PRD20
,      PRD21
,      PRD22
,      PRD23
,      PRD24
,      PRD25
,      PRD26
,      PRD27
,      PRD28
,      PRD29
,      PRD30
,      PRD31
,      PRD32
,      PRD33
,      PRD34
,      PRD35
,      PRD36
,      PRD37
,      PRD38
,      PRD39
,      PRD40
,      PRD41
,      PRD42
,      PRD43
,      PRD44
,      PRD45
,      PRD46
,      PRD47
,      PRD48
,      PRD49
,      PRD50
,      PRD51
,      PRD52
,      RECORD_VERSION_NUMBER
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_RATE_DATE_TYPE
,      PROJFUNC_EXCHANGE_RATE
,      PROJFUNC_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      PROJECT_RATE_DATE
,      FIN_PLAN_PREFERENCE_CODE
,      PLAN_CLASS_CODE
,      PROJECT_NUMBER
,      TASK_DISPLAY_SEQUENCE
,      RESOURCE_LIST_MEMBER_ID
,      AMOUNT_TYPE_CODE
,      SPREAD_CURVE_ID
,      SPREAD_CURVE
,      MFC_COST_TYPE_ID
,      MFC_COST_TYPE
,      ETC_METHOD_CODE
,      ETC_METHOD
,      ETC_SOURCE
,      PHYSICAL_PERCENT_COMPLETE
FROM PA.PA_FP_WEBADI_XFACE_TMP;

Dependencies

[top of page]

PA.PA_FP_WEBADI_XFACE_TMP does not reference any database object

PA.PA_FP_WEBADI_XFACE_TMP is referenced by following:

SchemaAPPS
SynonymPA_FP_WEBADI_XFACE_TMP