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

VIEW: APPS.PA_FP_WEBADI_PERIODIC_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[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.
PLAN_CLASS_CODE VARCHAR2 (30)
Plan Class for the plan type.
PROJECT_NAME VARCHAR2 (240)
The name of the project for which the budget is entered
PROJECT_NUMBER VARCHAR2 (25)
User-defined number that uniquely identifies the project for which the budget is entered
PROJECT_ID NUMBER (15)
Identifier 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_NAME VARCHAR2 (240)
User-defined short name of the task.
TASK_NUMBER VARCHAR2 (240)
User-defined number that uniquely identifies the task within a project.
TASK_DISPLAY_SEQUENCE NUMBER (15)
Display Sequence of the task within the project.
RESOURCE_NAME VARCHAR2 (240)
User-defined short name for a resource.
RESOURCE_LIST_MEMBER_ID NUMBER (15)
System-generated number that uniquely identifies a member within a resource list .
UNIT_OF_MEASURE VARCHAR2 (240)
The unit of measure of the resource.
TXN_CURRENCY_CODE VARCHAR2 (15)
The transaction currency code of the amount.
AMOUNT_TYPE_CODE VARCHAR2 (30)
Identifier of the amount type for a row in periodic layout .
AMOUNT_TYPE_NAME VARCHAR2 (240)
User-defined short name for the amount type for a row in periodic layout.
SPREAD_CURVE_ID NUMBER (15)
System-generated number that uniquely identifies the spread curve.
SPREAD_CURVE VARCHAR2 (240)
Indicates the spread curve name.
PLANNING_START_DATE DATE

Indicates the planning start date.
PLANNING_END_DATE DATE

Indicates the planning end date.
MFC_COST_TYPE_ID NUMBER (15)
System-generated number that uniquely identifies the manufacturing source.
MFC_COST_TYPE VARCHAR2 (10)
Indicates the manufacturing source.
ETC_METHOD_CODE VARCHAR2 (30)
Identifier of the estimate to complete method.
ETC_METHOD VARCHAR2 (80)
Indicates the estimate to complete method.
ETC_SOURCE VARCHAR2 (80)
Indicates the Transaction source code.
DELETE_FLAG VARCHAR2 (1)
Indicator for deleting data.
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.
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.
PHYSICAL_PERCENT_COMPLETE NUMBER (15)
Indicates the Task Physical Percentage Completion.
Query Text

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


SELECT BUDGET_VERSION_ID
,      FIN_PLAN_PREFERENCE_CODE
,      PLAN_CLASS_CODE
,      PROJECT_NAME
,      PROJECT_NUMBER
,      PROJECT_ID
,      RESOURCE_ASSIGNMENT_ID
,      TASK_NAME
,      TASK_NUMBER
,      TASK_DISPLAY_SEQUENCE
,      RESOURCE_NAME
,      RESOURCE_LIST_MEMBER_ID
,      UNIT_OF_MEASURE
,      TXN_CURRENCY_CODE
,      AMOUNT_TYPE_CODE
,      AMOUNT_TYPE_NAME
,      SPREAD_CURVE_ID
,      SPREAD_CURVE
,      PLANNING_START_DATE
,      PLANNING_END_DATE
,      MFC_COST_TYPE_ID
,      MFC_COST_TYPE
,      ETC_METHOD_CODE
,      ETC_METHOD
,      ETC_SOURCE
,      DELETE_FLAG
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_RATE_DATE_TYPE
,      PROJFUNC_RATE
,      PROJFUNC_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE_TYPE
,      PROJECT_RATE
,      PROJECT_RATE_DATE
,      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
,      PHYSICAL_PERCENT_COMPLETE
FROM APPS.PA_FP_WEBADI_PERIODIC_V;

Dependencies

[top of page]

APPS.PA_FP_WEBADI_PERIODIC_V references the following:

SchemaAPPS
SynonymPA_FP_WEBADI_XFACE_TMP
APPS.PA_FP_WEBADI_PERIODIC_V is referenced by following:

SchemaAPPS
ViewPA_FP_WEBADI_P_CUSTOM_V