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

VIEW: APPS.PA_FP_WEBADI_CUSTOM_V

Object Details
Object Name: PA_FP_WEBADI_CUSTOM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_FP_WEBADI_CUSTOM_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUDGET_VERSION_ID NUMBER (15)
FIN_PLAN_PREFERENCE_CODE VARCHAR2 (30)
PROJECT_NAME VARCHAR2 (30)
RESOURCE_ASSIGNMENT_ID NUMBER (15)
TASK_NUM VARCHAR2 (25)
TASK_NAME VARCHAR2 (20)
RESOURCE_GP_NAME VARCHAR2 (80)
RESOURCE_NAME VARCHAR2 (80)
START_DATE DATE

END_DATE DATE

QUANTITY NUMBER

RAW_COST NUMBER

BURDENED_COST NUMBER

REVENUE NUMBER

AMOUNT_TYPE_NAME VARCHAR2 (80)
AMOUNT_TYPE_CODE VARCHAR2 (30)
AMOUNT_SUBTYPE_CODE VARCHAR2 (30)
AMOUNT_TYPE_ORDER NUMBER

TXN_CURRENCY_CODE VARCHAR2 (15)
PRED_PERIODS NUMBER

SUCD_PERIODS 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

UOM VARCHAR2 (80)
DESCRIPTION VARCHAR2 (255)
CHANGE_REASON VARCHAR2 (80)
PROJFUNC_CR_TYPE VARCHAR2 (30)
PROJFUNC_CR_DATE_TYPE VARCHAR2 (80)
PROJECT_CR_TYPE VARCHAR2 (30)
PROJECT_CR_DATE_TYPE VARCHAR2 (80)
PROJFUNC_RR_TYPE VARCHAR2 (30)
PROJFUNC_RR_DATE_TYPE VARCHAR2 (80)
PROJECT_RR_TYPE VARCHAR2 (30)
PROJECT_RR_DATE_TYPE VARCHAR2 (80)
PROJFUNC_COST_RATE NUMBER

PROJFUNC_CR_DATE DATE

PROJECT_COST_RATE NUMBER

PROJECT_CR_DATE DATE

PROJFUNC_REV_RATE NUMBER

PROJFUNC_RR_DATE DATE

PROJECT_REV_RATE NUMBER

PROJECT_RR_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)
PROJFUNC_RATE_TYPE VARCHAR2 (30)
PROJFUNC_DATE_TYPE VARCHAR2 (80)
PROJECT_RATE_TYPE VARCHAR2 (30)
PROJECT_DATE_TYPE VARCHAR2 (80)
PROJFUNC_RATE NUMBER

PROJFUNC_DATE DATE

PROJECT_RATE NUMBER

PROJECT_DATE DATE

CUSTOM_COL1 VARCHAR2 (0)
CUSTOM_COL2 VARCHAR2 (0)
CUSTOM_COL3 VARCHAR2 (0)
CUSTOM_COL4 VARCHAR2 (0)
CUSTOM_COL5 VARCHAR2 (0)
CUSTOM_COL6 VARCHAR2 (0)
CUSTOM_COL7 VARCHAR2 (0)
CUSTOM_COL8 VARCHAR2 (0)
CUSTOM_COL9 VARCHAR2 (0)
CUSTOM_COL10 VARCHAR2 (0)
CUSTOM_COL11 VARCHAR2 (0)
CUSTOM_COL12 VARCHAR2 (0)
CUSTOM_COL13 VARCHAR2 (0)
CUSTOM_COL14 VARCHAR2 (0)
CUSTOM_COL15 VARCHAR2 (0)
Query Text

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


SELECT BUDGET_VERSION_ID
,      FIN_PLAN_PREFERENCE_CODE
,      PROJECT_NAME
,      RESOURCE_ASSIGNMENT_ID
,      TASK_NUM
,      TASK_NAME
,      RESOURCE_GP_NAME
,      RESOURCE_NAME
,      START_DATE
,      END_DATE
,      QUANTITY
,      RAW_COST
,      BURDENED_COST
,      REVENUE
,      AMOUNT_TYPE_NAME
,      AMOUNT_TYPE_CODE
,      AMOUNT_SUBTYPE_CODE
,      AMOUNT_TYPE_ORDER
,      TXN_CURRENCY_CODE
,      PRED_PERIODS
,      SUCD_PERIODS
,      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
,      UOM
,      DESCRIPTION
,      CHANGE_REASON
,      PROJFUNC_CR_TYPE
,      PROJFUNC_CR_DATE_TYPE
,      PROJECT_CR_TYPE
,      PROJECT_CR_DATE_TYPE
,      PROJFUNC_RR_TYPE
,      PROJFUNC_RR_DATE_TYPE
,      PROJECT_RR_TYPE
,      PROJECT_RR_DATE_TYPE
,      PROJFUNC_COST_RATE
,      PROJFUNC_CR_DATE
,      PROJECT_COST_RATE
,      PROJECT_CR_DATE
,      PROJFUNC_REV_RATE
,      PROJFUNC_RR_DATE
,      PROJECT_REV_RATE
,      PROJECT_RR_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_DATE_TYPE
,      PROJECT_RATE_TYPE
,      PROJECT_DATE_TYPE
,      PROJFUNC_RATE
,      PROJFUNC_DATE
,      PROJECT_RATE
,      PROJECT_DATE
,      CUSTOM_COL1
,      CUSTOM_COL2
,      CUSTOM_COL3
,      CUSTOM_COL4
,      CUSTOM_COL5
,      CUSTOM_COL6
,      CUSTOM_COL7
,      CUSTOM_COL8
,      CUSTOM_COL9
,      CUSTOM_COL10
,      CUSTOM_COL11
,      CUSTOM_COL12
,      CUSTOM_COL13
,      CUSTOM_COL14
,      CUSTOM_COL15
FROM APPS.PA_FP_WEBADI_CUSTOM_V;

Dependencies

[top of page]

APPS.PA_FP_WEBADI_CUSTOM_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackagePA_CROSS_BUSINESS_GRP - show dependent code
PL/SQL PackagePA_FIN_PLAN_UTILS - show dependent code
ViewPA_FP_WEBADI_CONTENTS_V

APPS.PA_FP_WEBADI_CUSTOM_V is not referenced by any database object