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

TABLE: PA.PA_FP_WEBADI_UPLOAD_INF

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


This is the internal interface table used in Microsoft Excel Budgeting and Forecasting Integration to transfer data from excel to Oracle Projects.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_FP_WEBADI_UPLOAD_INF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRUN_ID
Columns
Name Datatype Length Mandatory Comments
RUN_ID NUMBER (15)
Identifier of the batch for a version for which upload processing takes place at any given time
BUDGET_VERSION_ID NUMBER (15)
Identifier of the version being processed for a batch
RECORD_VERSION_NUMBER NUMBER (15)
Record version number of the version for which data has been uploaded
PRD_MASK_REC_VER_NUMBER NUMBER (15)
Record version number of the period profile associated with a time phased version stored at the time of download
TASK_NAME VARCHAR2 (240)
User-defined short name of the task
TASK_NUMBER VARCHAR2 (100)
User-defined number that uniquely identifies the task within a project
TASK_ID NUMBER (15)
The system-generated number that uniquely identifies the task
RESOURCE_ALIAS VARCHAR2 (80)
User-defined short name for a resource
RESOURCE_LIST_MEMBER_ID NUMBER (15)
The system-generated number that uniquely identifies the resource list member
AMOUNT_TYPE_CODE VARCHAR2 (30)
Identifier of the amount type for a row in periodic layout
AMOUNT_TYPE_NAME VARCHAR2 (80)
Identifier of the amount type name for a row in periodic layout
TXN_CURRENCY_CODE VARCHAR2 (15)
The transaction currency code of the amount
DELETE_FLAG VARCHAR2 (1)
Indicator for deleting data
PLANNING_START_DATE DATE

Indicates the planning start date
PLANNING_END_DATE DATE

Indicates the planning end date
DESCRIPTION VARCHAR2 (255)
The description of the budget line
CHANGE_REASON_CODE VARCHAR2 (30)
The reason to create the budget line
QUANTITY NUMBER

The quantity of the budget line
ACTUAL_QUANTITY NUMBER

The actual quantity in the budget line
ETC_QUANTITY NUMBER

The estimate to complete quantity of the budget line
RAW_COST NUMBER

The raw cost of the budget line
ACTUAL_RAW_COST NUMBER

The actual raw cost in the budget line
ETC_RAW_COST NUMBER

The estimate to complete raw cost of the budget line
RAW_COST_RATE NUMBER

The raw cost rate of the budget line
BURDENED_COST NUMBER

The burdened cost of the budget line
ACTUAL_BURDENED_COST NUMBER

The actual burden cost in the budget line
ETC_BURDENED_COST NUMBER

The estimate to complete burdened cost of the budget line
BURDENED_COST_RATE NUMBER

The burdened cost rate of the budget line
REVENUE NUMBER

The revenue of the budget line
ACTUAL_REVENUE NUMBER

The actual revenue in the budget line
ETC_REVENUE NUMBER

The estimate to complete revenue of the budget line
BILL_RATE NUMBER

The bill rate of the budget line
PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
The project functional cost rate type
PROJFUNC_COST_RATE_DATE_TYPE VARCHAR2 (30)
The project functional cost rate date type
PROJFUNC_COST_EXCHANGE_RATE NUMBER

The project functional cost exchange rate
PROJFUNC_COST_RATE_DATE DATE

The cost rate date for project functional currency
PROJECT_COST_RATE_TYPE VARCHAR2 (30)
The project cost rate type
PROJECT_COST_RATE_DATE_TYPE VARCHAR2 (30)
The project cost rate date type
PROJECT_COST_EXCHANGE_RATE NUMBER

The project cost exchange rate
PROJECT_COST_RATE_DATE DATE

The cost rate date for project currency
PROJFUNC_REV_RATE_TYPE VARCHAR2 (30)
The project functional revenue rate type
PROJFUNC_REV_RATE_DATE_TYPE VARCHAR2 (30)
The project functional revenue rate date type
PROJFUNC_REV_EXCHANGE_RATE NUMBER

The project functional revenue exchange rate
PROJFUNC_REV_RATE_DATE DATE

The revenue rate date for project functional currency
PROJECT_REV_RATE_TYPE VARCHAR2 (30)
The project revenue rate type
PROJECT_REV_RATE_DATE_TYPE VARCHAR2 (30)
The project revenue rate date type
PROJECT_REV_EXCHANGE_RATE NUMBER

The project revenue exchange rate
PROJECT_REV_RATE_DATE DATE

The revenue rate date for project currency
PROJFUNC_RATE_TYPE VARCHAR2 (30)
The project functional rate type
PROJFUNC_RATE_DATE_TYPE VARCHAR2 (30)
The project functional rate date type
PROJFUNC_EXCHANGE_RATE NUMBER

The project functional exchange rate
PROJFUNC_RATE_DATE DATE

The rate date for project functional currency
PROJECT_RATE_TYPE VARCHAR2 (30)
The project rate type
PROJECT_RATE_DATE_TYPE VARCHAR2 (30)
The project rate date type
PROJECT_EXCHANGE_RATE NUMBER

The project exchange rate
PROJECT_RATE_DATE DATE

The rate date for project currency
VAL_ERROR_FLAG VARCHAR2 (1)
Indicator used to indicate invalid entry in the table.
VAL_ERROR_CODE VARCHAR2 (30)
Error message code stamped pertaining to a particular validation failure
ERR_TASK_NAME VARCHAR2 (240)
Task name of the row for which error indicator exists
ERR_TASK_NUMBER VARCHAR2 (100)
Task number of the row for which error indicator exists
ERR_ALIAS VARCHAR2 (80)
Resource alias of the row for which error indicator exists
ERR_AMOUNT_TYPE_CODE VARCHAR2 (30)
Amount type code of the row for which error indicator exists
REQUEST_ID NUMBER (15)
The concurrent request id being processed
PD_PRD NUMBER

Place holder for amount in the preceeding period
PRD1 NUMBER

Place holder for amount in the period 1
PRD2 NUMBER

Place holder for amount in the period 2
PRD3 NUMBER

Place holder for amount in the period 3
PRD4 NUMBER

Place holder for amount in the period 4
PRD5 NUMBER

Place holder for amount in the period 5
PRD6 NUMBER

Place holder for amount in the period 6
PRD7 NUMBER

Place holder for amount in the period 7
PRD8 NUMBER

Place holder for amount in the period 8
PRD9 NUMBER

Place holder for amount in the period 9
PRD10 NUMBER

Place holder for amount in the period 10
PRD11 NUMBER

Place holder for amount in the period 11
PRD12 NUMBER

Place holder for amount in the period 12
PRD13 NUMBER

Place holder for amount in the period 13
PRD14 NUMBER

Place holder for amount in the period 14
PRD15 NUMBER

Place holder for amount in the period 15
PRD16 NUMBER

Place holder for amount in the period 16
PRD17 NUMBER

Place holder for amount in the period 17
PRD18 NUMBER

Place holder for amount in the period 18
PRD19 NUMBER

Place holder for amount in the period 19
PRD20 NUMBER

Place holder for amount in the period 20
PRD21 NUMBER

Place holder for amount in the period 21
PRD22 NUMBER

Place holder for amount in the period 22
PRD23 NUMBER

Place holder for amount in the period 23
PRD24 NUMBER

Place holder for amount in the period 24
PRD25 NUMBER

Place holder for amount in the period 25
PRD26 NUMBER

Place holder for amount in the period 26
PRD27 NUMBER

Place holder for amount in the period 27
PRD28 NUMBER

Place holder for amount in the period 28
PRD29 NUMBER

Place holder for amount in the period 29
PRD30 NUMBER

Place holder for amount in the period 30
PRD31 NUMBER

Place holder for amount in the period 31
PRD32 NUMBER

Place holder for amount in the period 32
PRD33 NUMBER

Place holder for amount in the period 33
PRD34 NUMBER

Place holder for amount in the period 34
PRD35 NUMBER

Place holder for amount in the period 35
PRD36 NUMBER

Place holder for amount in the period 36
PRD37 NUMBER

Place holder for amount in the period 37
PRD38 NUMBER

Place holder for amount in the period 38
PRD39 NUMBER

Place holder for amount in the period 39
PRD40 NUMBER

Place holder for amount in the period 40
PRD41 NUMBER

Place holder for amount in the period 41
PRD42 NUMBER

Place holder for amount in the period 42
PRD43 NUMBER

Place holder for amount in the period 43
PRD44 NUMBER

Place holder for amount in the period 44
PRD45 NUMBER

Place holder for amount in the period 45
PRD46 NUMBER

Place holder for amount in the period 46
PRD47 NUMBER

Place holder for amount in the period 47
PRD48 NUMBER

Place holder for amount in the period 48
PRD49 NUMBER

Place holder for amount in the period 49
PRD50 NUMBER

Place holder for amount in the period 50
PRD51 NUMBER

Place holder for amount in the period 51
PRD52 NUMBER

Place holder for amount in the period 52
SD_PRD NUMBER

Place holder for amount in the succeeding period
ETC_RAW_COST_RATE NUMBER

The ETC raw cost rate at the planning transaction level.
ETC_BURDEN_COST_RATE NUMBER

The ETC burden cost rate at the planning transaction level.
ETC_BILL_RATE NUMBER

The ETC bill rate at the planning transaction level.
RAW_COST_OVER_RATE NUMBER

The overriding cost rate at the planning transaction level.
BURDENED_COST_OVER_RATE NUMBER

The overriding burden cost rate at the planning transaction level.
BILL_OVER_RATE NUMBER

The overriding bill rate at the planning transaction level.
COST_CODE VARCHAR2 (250)
This represents the cost code.
COST_CODE_NAME VARCHAR2 (240)
This represents the cost code name.
CBS_ELEMENT_ID NUMBER (15)
This is the unique identifier of the cost code element.
Query Text

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


SELECT RUN_ID
,      BUDGET_VERSION_ID
,      RECORD_VERSION_NUMBER
,      PRD_MASK_REC_VER_NUMBER
,      TASK_NAME
,      TASK_NUMBER
,      TASK_ID
,      RESOURCE_ALIAS
,      RESOURCE_LIST_MEMBER_ID
,      AMOUNT_TYPE_CODE
,      AMOUNT_TYPE_NAME
,      TXN_CURRENCY_CODE
,      DELETE_FLAG
,      PLANNING_START_DATE
,      PLANNING_END_DATE
,      DESCRIPTION
,      CHANGE_REASON_CODE
,      QUANTITY
,      ACTUAL_QUANTITY
,      ETC_QUANTITY
,      RAW_COST
,      ACTUAL_RAW_COST
,      ETC_RAW_COST
,      RAW_COST_RATE
,      BURDENED_COST
,      ACTUAL_BURDENED_COST
,      ETC_BURDENED_COST
,      BURDENED_COST_RATE
,      REVENUE
,      ACTUAL_REVENUE
,      ETC_REVENUE
,      BILL_RATE
,      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
,      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
,      VAL_ERROR_FLAG
,      VAL_ERROR_CODE
,      ERR_TASK_NAME
,      ERR_TASK_NUMBER
,      ERR_ALIAS
,      ERR_AMOUNT_TYPE_CODE
,      REQUEST_ID
,      PD_PRD
,      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
,      SD_PRD
,      ETC_RAW_COST_RATE
,      ETC_BURDEN_COST_RATE
,      ETC_BILL_RATE
,      RAW_COST_OVER_RATE
,      BURDENED_COST_OVER_RATE
,      BILL_OVER_RATE
,      COST_CODE
,      COST_CODE_NAME
,      CBS_ELEMENT_ID
FROM PA.PA_FP_WEBADI_UPLOAD_INF;

Dependencies

[top of page]

PA.PA_FP_WEBADI_UPLOAD_INF does not reference any database object

PA.PA_FP_WEBADI_UPLOAD_INF is referenced by following:

SchemaPA
ViewPA_FP_WEBADI_UPLOAD_INF#