eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_FP_OF_WEBADI_V

Object Details

Object Name:	PA_FP_OF_WEBADI_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_FP_OF_WEBADI_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
CATEGORY_ID	NUMBER	(15)
CATEGORY	VARCHAR2	(80)
OU_ID	NUMBER
OU_NAME	VARCHAR2	(240)
ORGANIZATION_ID	NUMBER
ORGANIZATION_NAME	VARCHAR2	(240)
OTHER_OU_ID	NUMBER	(15)
OTHER_OU_NAME	VARCHAR2	(240)
OTHER_ORGANIZATION_ID	NUMBER	(15)
OTHER_ORGANIZATION_NAME	VARCHAR2	(240)
TXN_PROJECT_NAME	VARCHAR2	(30)
RESOURCE_NAME	VARCHAR2	(240)
PERIOD1	NUMBER
PERIOD2	NUMBER
PERIOD3	NUMBER
PERIOD4	NUMBER
PERIOD5	NUMBER
PERIOD6	NUMBER
PERIOD7	NUMBER
PERIOD8	NUMBER
PERIOD9	NUMBER
PERIOD10	NUMBER
PERIOD11	NUMBER
PERIOD12	NUMBER
PERIOD13	NUMBER
PERIOD14	NUMBER
PERIOD15	NUMBER
PERIOD16	NUMBER
PERIOD17	NUMBER
PERIOD18	NUMBER
PERIOD19	NUMBER
PERIOD20	NUMBER
PERIOD21	NUMBER
PERIOD22	NUMBER
PERIOD23	NUMBER
PERIOD24	NUMBER
PERIOD25	NUMBER
PERIOD26	NUMBER
PERIOD27	NUMBER
PERIOD28	NUMBER
PERIOD29	NUMBER
PERIOD30	NUMBER
PERIOD31	NUMBER
PERIOD32	NUMBER
PERIOD33	NUMBER
PERIOD34	NUMBER
PERIOD35	NUMBER
PERIOD36	NUMBER
PERIOD37	NUMBER
PERIOD38	NUMBER
PERIOD39	NUMBER
PERIOD40	NUMBER
PERIOD41	NUMBER
PERIOD42	NUMBER
PERIOD43	NUMBER
PERIOD44	NUMBER
PERIOD45	NUMBER
PERIOD46	NUMBER
PERIOD47	NUMBER
PERIOD48	NUMBER
PERIOD49	NUMBER
PERIOD50	NUMBER
PERIOD51	NUMBER
PERIOD52	NUMBER

Query Text

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


SELECT CATEGORY_ID
,      CATEGORY
,      OU_ID
,      OU_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      OTHER_OU_ID
,      OTHER_OU_NAME
,      OTHER_ORGANIZATION_ID
,      OTHER_ORGANIZATION_NAME
,      TXN_PROJECT_NAME
,      RESOURCE_NAME
,      PERIOD1
,      PERIOD2
,      PERIOD3
,      PERIOD4
,      PERIOD5
,      PERIOD6
,      PERIOD7
,      PERIOD8
,      PERIOD9
,      PERIOD10
,      PERIOD11
,      PERIOD12
,      PERIOD13
,      PERIOD14
,      PERIOD15
,      PERIOD16
,      PERIOD17
,      PERIOD18
,      PERIOD19
,      PERIOD20
,      PERIOD21
,      PERIOD22
,      PERIOD23
,      PERIOD24
,      PERIOD25
,      PERIOD26
,      PERIOD27
,      PERIOD28
,      PERIOD29
,      PERIOD30
,      PERIOD31
,      PERIOD32
,      PERIOD33
,      PERIOD34
,      PERIOD35
,      PERIOD36
,      PERIOD37
,      PERIOD38
,      PERIOD39
,      PERIOD40
,      PERIOD41
,      PERIOD42
,      PERIOD43
,      PERIOD44
,      PERIOD45
,      PERIOD46
,      PERIOD47
,      PERIOD48
,      PERIOD49
,      PERIOD50
,      PERIOD51
,      PERIOD52
FROM APPS.PA_FP_OF_WEBADI_V;

Dependencies

[top of page]

APPS.PA_FP_OF_WEBADI_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; PA_AMOUNT_TYPES_VL; PA_BUDGET_VERSIONS; PA_FIN_PLAN_VIEW_GLOBAL - show dependent code; PA_ORG_FCST_ELEMENTS; PA_PROJECTS_ALL; PA_PROJECT_ASSIGNMENTS; PA_PROJ_PERIODS_DENORM; PA_RESOURCES; PA_RESOURCE_ASSIGNMENTS; PA_WORK_TYPES_B

APPS.PA_FP_OF_WEBADI_V is referenced by following:

APPS: PA_FP_OF_WEBADI_PKG - show dependent code