Skip to content

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

TABLE: PA.PA_FP_WEBADI_XFACE_TMP1

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
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)
COST_CODE VARCHAR2 (250)
COST_CODE_NAME VARCHAR2 (240)
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
,      COST_CODE
,      COST_CODE_NAME
FROM PA.PA_FP_WEBADI_XFACE_TMP1;

Dependencies

[top of page]

PA.PA_FP_WEBADI_XFACE_TMP1 does not reference any database object

PA.PA_FP_WEBADI_XFACE_TMP1 is referenced by following:

SchemaPA
ViewPA_FP_WEBADI_XFACE_TMP1#