[Home] [Help] [Dependency Information]
Object Name: | PA_FP_WEBADI_UPLOAD_INF# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RUN_ID | NUMBER | (15) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
RECORD_VERSION_NUMBER | NUMBER | (15) | ||
PRD_MASK_REC_VER_NUMBER | NUMBER | (15) | ||
TASK_NAME | VARCHAR2 | (240) | ||
TASK_NUMBER | VARCHAR2 | (100) | ||
TASK_ID | NUMBER | (15) | ||
RESOURCE_ALIAS | VARCHAR2 | (80) | ||
RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | ||
AMOUNT_TYPE_CODE | VARCHAR2 | (30) | ||
AMOUNT_TYPE_NAME | VARCHAR2 | (80) | ||
TXN_CURRENCY_CODE | VARCHAR2 | (15) | ||
DELETE_FLAG | VARCHAR2 | (1) | ||
PLANNING_START_DATE | DATE | |||
PLANNING_END_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (255) | ||
CHANGE_REASON_CODE | VARCHAR2 | (30) | ||
QUANTITY | NUMBER | |||
ACTUAL_QUANTITY | NUMBER | |||
ETC_QUANTITY | NUMBER | |||
RAW_COST | NUMBER | |||
ACTUAL_RAW_COST | NUMBER | |||
ETC_RAW_COST | NUMBER | |||
RAW_COST_RATE | NUMBER | |||
BURDENED_COST | NUMBER | |||
ACTUAL_BURDENED_COST | NUMBER | |||
ETC_BURDENED_COST | NUMBER | |||
BURDENED_COST_RATE | NUMBER | |||
REVENUE | NUMBER | |||
ACTUAL_REVENUE | NUMBER | |||
ETC_REVENUE | NUMBER | |||
BILL_RATE | NUMBER | |||
PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_COST_RATE_DATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_COST_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_COST_RATE_DATE | DATE | |||
PROJECT_COST_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_COST_RATE_DATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_COST_EXCHANGE_RATE | NUMBER | |||
PROJECT_COST_RATE_DATE | DATE | |||
PROJFUNC_REV_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_REV_RATE_DATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_REV_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_REV_RATE_DATE | DATE | |||
PROJECT_REV_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_REV_RATE_DATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_REV_EXCHANGE_RATE | NUMBER | |||
PROJECT_REV_RATE_DATE | DATE | |||
PROJFUNC_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_RATE_DATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_RATE_DATE | DATE | |||
PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_RATE_DATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_EXCHANGE_RATE | NUMBER | |||
PROJECT_RATE_DATE | DATE | |||
VAL_ERROR_FLAG | VARCHAR2 | (1) | ||
VAL_ERROR_CODE | VARCHAR2 | (30) | ||
ERR_TASK_NAME | VARCHAR2 | (240) | ||
ERR_TASK_NUMBER | VARCHAR2 | (100) | ||
ERR_ALIAS | VARCHAR2 | (80) | ||
ERR_AMOUNT_TYPE_CODE | VARCHAR2 | (30) | ||
REQUEST_ID | NUMBER | (15) | ||
PD_PRD | NUMBER | |||
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 | |||
SD_PRD | NUMBER | |||
ETC_RAW_COST_RATE | NUMBER | |||
ETC_BURDEN_COST_RATE | NUMBER | |||
ETC_BILL_RATE | NUMBER | |||
RAW_COST_OVER_RATE | NUMBER | |||
BURDENED_COST_OVER_RATE | NUMBER | |||
BILL_OVER_RATE | NUMBER | |||
COST_CODE | VARCHAR2 | (250) | ||
COST_CODE_NAME | VARCHAR2 | (240) | ||
CBS_ELEMENT_ID | NUMBER | (15) |
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#;
|
|
|