Skip to content

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

VIEW: PA.PA_FP_WEBADI_UPLOAD_INF#

Object Details
Object Name: PA_FP_WEBADI_UPLOAD_INF#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
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)
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# references the following:

SchemaPA
TablePA_FP_WEBADI_UPLOAD_INF
PA.PA_FP_WEBADI_UPLOAD_INF# is referenced by following:

SchemaAPPS
SynonymPA_FP_WEBADI_UPLOAD_INF