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

VIEW: APPS.FPA_AW_PROJS_V

Object Details
Object Name: FPA_AW_PROJS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFPA.FPA_AW_PROJS_V
Subobject Name:
Status: VALID

View Type

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


FPA_AW_PROJS_V is a view containing Project information, its class code, its Portfolio and the Planning Cycles where it has been collected.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT NUMBER

Unique identifier for Projects
CLASS_CODE NUMBER

Class Code
PORTFOLIO NUMBER

Portfolio ID for the project
PLANNING_CYCLE NUMBER

Planning Cycle ID for the project
Query Text

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


SELECT PROJECT
,      CLASS_CODE
,      PORTFOLIO
,      PLANNING_CYCLE
FROM APPS.FPA_AW_PROJS_V;

Dependencies

[top of page]

APPS.FPA_AW_PROJS_V references the following:

SchemaAPPS
TYPEFPA_PROJ_TBL
PL/SQL PackageFPA_UTILITIES_PVT - show dependent code
SchemaPUBLIC
SynonymOLAP_TABLE
APPS.FPA_AW_PROJS_V is referenced by following:

SchemaAPPS
Package BodyFPA_MAIN_PROCESS_PVT - show dependent code
Package BodyFPA_PROCESS_PVT - show dependent code
Package BodyFPA_VALIDATION_PROCESS_PVT - show dependent code