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.FPA_AW_PROJ_INV_RANK_MAPS_V

Object Details

Object Name:	FPA_AW_PROJ_INV_RANK_MAPS_V
Object Type:	VIEW
Owner:	APPS
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
SCENARIO	NUMBER
PLANNING_CYCLE	NUMBER
PROJECT	NUMBER
INVESTMENT_CRITERIA	NUMBER
CURRENT_FUNDING_STATUS	VARCHAR2	(30)
CLASS_CODE	NUMBER
RECOMMENDED_FUNDING_STATUS	VARCHAR2	(30)
PC_DISPLAY_FACTOR	VARCHAR2	(30)
WEIGHTED_SCORE	NUMBER
USER_RANK	NUMBER
INVESTMENT_INDEX	NUMBER
RISK_PERCENTILE	NUMBER
FIN_PERCENTILE	NUMBER
STR_PERCENTILE	NUMBER
NET_PRESENT_VALUE	NUMBER
FUNDS_REQUIRED	NUMBER
SCENARIO_PROJECT_VALID	NUMBER

Query Text

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


SELECT SCENARIO
,      PLANNING_CYCLE
,      PROJECT
,      INVESTMENT_CRITERIA
,      CURRENT_FUNDING_STATUS
,      CLASS_CODE
,      RECOMMENDED_FUNDING_STATUS
,      PC_DISPLAY_FACTOR
,      WEIGHTED_SCORE
,      USER_RANK
,      INVESTMENT_INDEX
,      RISK_PERCENTILE
,      FIN_PERCENTILE
,      STR_PERCENTILE
,      NET_PRESENT_VALUE
,      FUNDS_REQUIRED
,      SCENARIO_PROJECT_VALID
FROM APPS.FPA_AW_PROJ_INV_RANK_MAPS_V;

Dependencies

[top of page]

APPS.FPA_AW_PROJ_INV_RANK_MAPS_V references the following:

APPS: FPA_PROJ_INV_RANK_MAP_TBL; FPA_UTILITIES_PVT - show dependent code
PUBLIC: OLAP_TABLE

APPS.FPA_AW_PROJ_INV_RANK_MAPS_V is not referenced by any database object