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

VIEW: APPS.PA_FP_WEBADI_P_CUSTOM_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


You can choose to add additional columns for download in periodic budget/forecast to Excel Spreadsheet. You can fetch additional information by modifying data fetched by columns CUSTOM_COL1 to CUSTOM_COL15 and recreating the view with the modified select. Modifying the fetch logic of any other columns is not recommended and may give unexpected results. Columns CUSTOM_COL1 to CUSTOM_COL15 can then be viewed during budgeting and forecasting excel download using periodic layout by adding these columns to the customized layouts associated to the corresponding financial plan types. Changes to the above columns would only be effective and used during download and are not used during upload of data to Oracle Projects.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUDGET_VERSION_ID NUMBER (15) Yes Identifier of the plan version.
FIN_PLAN_PREFERENCE_CODE VARCHAR2 (30)
Indicates the planning preference.
PROJECT_NAME VARCHAR2 (240)
The name of the project for which the budget is entered
RESOURCE_ASSIGNMENT_ID NUMBER (15)
The system-generated number that uniquely identifies the resource list member.
TASK_NUMBER VARCHAR2 (240)
User-defined number that uniquely identifies the task within a project.
TASK_NAME VARCHAR2 (240)
User-defined short name of the task.
TASK_DISPLAY_SEQUENCE NUMBER (15)
Display Sequence of the task within the project.
RESOURCE_NAME VARCHAR2 (240)
User-defined short name for a resource.
PLANNING_START_DATE DATE

Indicates the planning start date.
PLANNING_END_DATE DATE

Indicates the planning end date.
AMOUNT_TYPE_NAME VARCHAR2 (240)
User-defined short name for the amount type for a row in periodic layout.
AMOUNT_TYPE_CODE VARCHAR2 (30)
Identifier of the amount type for a row in periodic layout .
TXN_CURRENCY_CODE VARCHAR2 (15)
The transaction currency code of the amount.
MFC_COST_TYPE VARCHAR2 (10)
Indicates the manufacturing source.
ETC_METHOD VARCHAR2 (80)
Indicates the estimate to complete method.
ETC_SOURCE VARCHAR2 (80)
Indicates the Transaction source code.
SPREAD_CURVE VARCHAR2 (240)
Indicates the spread curve name.
PRECEDING_PERIOD 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.
SUCCEEDING_PERIOD NUMBER

Place holder for amount in the succeeding period.
UNIT_OF_MEASURE VARCHAR2 (240)
The unit of measure of the resource.
PROJFUNC_RATE_TYPE VARCHAR2 (240)
The project functional rate type.
PROJFUNC_RATE_DATE_TYPE VARCHAR2 (240)
The project functional rate date type.
PROJFUNC_RATE NUMBER

The project functional exchange rate.
PROJFUNC_RATE_DATE DATE

The rate date for project functional currency.
PROJECT_RATE_TYPE VARCHAR2 (240)
The project rate type.
PROJECT_RATE_DATE_TYPE VARCHAR2 (240)
The project rate date type.
PROJECT_RATE NUMBER

The project exchange rate.
PROJECT_RATE_DATE DATE

The rate date for project currency.
CUSTOM_COL1 VARCHAR2 (0)
User customizable column 1.
CUSTOM_COL2 VARCHAR2 (0)
User customizable column 2.
CUSTOM_COL3 VARCHAR2 (0)
User customizable column 3.
CUSTOM_COL4 VARCHAR2 (0)
User customizable column 4.
CUSTOM_COL5 VARCHAR2 (0)
User customizable column 5.
CUSTOM_COL6 VARCHAR2 (0)
User customizable column 6.
CUSTOM_COL7 VARCHAR2 (0)
User customizable column 7.
CUSTOM_COL8 VARCHAR2 (0)
User customizable column 8.
CUSTOM_COL9 VARCHAR2 (0)
User customizable column 9.
CUSTOM_COL10 VARCHAR2 (0)
User customizable column 10.
CUSTOM_COL11 VARCHAR2 (0)
User customizable column 11.
CUSTOM_COL12 VARCHAR2 (0)
User customizable column 12.
CUSTOM_COL13 VARCHAR2 (0)
User customizable column 13.
CUSTOM_COL14 VARCHAR2 (0)
User customizable column 14.
CUSTOM_COL15 VARCHAR2 (0)
User customizable column 15.
DELETE_FLAG VARCHAR2 (1)
Indicator for deleting data.
PHYSICAL_PERCENT_COMPLETE NUMBER (15)
Indicates the Task Physical Percentage Completion.
RECORD_VERSION_NUMBER NUMBER

Record version number of the plan being processed.
COST_CODE VARCHAR2 (250)
Cost Code selected for the task assignment.
COST_CODE_NAME VARCHAR2 (240)
Cost Code Name selected for the task assignment.
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_NUMBER
,      TASK_NAME
,      TASK_DISPLAY_SEQUENCE
,      RESOURCE_NAME
,      PLANNING_START_DATE
,      PLANNING_END_DATE
,      AMOUNT_TYPE_NAME
,      AMOUNT_TYPE_CODE
,      TXN_CURRENCY_CODE
,      MFC_COST_TYPE
,      ETC_METHOD
,      ETC_SOURCE
,      SPREAD_CURVE
,      PRECEDING_PERIOD
,      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
,      SUCCEEDING_PERIOD
,      UNIT_OF_MEASURE
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_RATE_DATE_TYPE
,      PROJFUNC_RATE
,      PROJFUNC_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE_TYPE
,      PROJECT_RATE
,      PROJECT_RATE_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
,      DELETE_FLAG
,      PHYSICAL_PERCENT_COMPLETE
,      RECORD_VERSION_NUMBER
,      COST_CODE
,      COST_CODE_NAME
FROM APPS.PA_FP_WEBADI_P_CUSTOM_V;

Dependencies

[top of page]

APPS.PA_FP_WEBADI_P_CUSTOM_V references the following:

SchemaAPPS
ViewPA_FP_WEBADI_PERIODIC_V

APPS.PA_FP_WEBADI_P_CUSTOM_V is not referenced by any database object