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

VIEW: APPS.FPA_AW_SCE_SUM_CATS_V

Object Details
Object Name: FPA_AW_SCE_SUM_CATS_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 Mandatory Comments
SCENARIO NUMBER

CLASS_CODE NUMBER

INVESTMENT_CRITERIA NUMBER

PLANNING_CYCLE NUMBER

PC_DISCOUNT_RATE NUMBER

PC_FUNDING NUMBER

PC_DISPLAY_FACTOR VARCHAR2 (30)
SCC_FUNDS_AVAILABLE NUMBER

SCC_FUNDS_REQUIRED NUMBER

SCC_FUNDING_VARIANCE NUMBER

SCC_TOTAL_BENEFIT NUMBER

SCC_NET_PRESENT_VALUE NUMBER

SCC_INTERNAL_RATE_RETURN NUMBER

SCC_RETURN_ON_INV NUMBER

SCC_PAYBACK_PERIOD NUMBER

SCC_WEIGHTED_SCORE NUMBER

SCC_COST_WEIGHTED_SCORE NUMBER

SCE_CLASS_CODE_VALID NUMBER

Query Text

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


SELECT SCENARIO
,      CLASS_CODE
,      INVESTMENT_CRITERIA
,      PLANNING_CYCLE
,      PC_DISCOUNT_RATE
,      PC_FUNDING
,      PC_DISPLAY_FACTOR
,      SCC_FUNDS_AVAILABLE
,      SCC_FUNDS_REQUIRED
,      SCC_FUNDING_VARIANCE
,      SCC_TOTAL_BENEFIT
,      SCC_NET_PRESENT_VALUE
,      SCC_INTERNAL_RATE_RETURN
,      SCC_RETURN_ON_INV
,      SCC_PAYBACK_PERIOD
,      SCC_WEIGHTED_SCORE
,      SCC_COST_WEIGHTED_SCORE
,      SCE_CLASS_CODE_VALID
FROM APPS.FPA_AW_SCE_SUM_CATS_V;

Dependencies

[top of page]

APPS.FPA_AW_SCE_SUM_CATS_V references the following:

SchemaAPPS
TYPEFPA_SCEN_SUM_CAT_VO_TBL
PL/SQL PackageFPA_UTILITIES_PVT - show dependent code
SchemaPUBLIC
SynonymOLAP_TABLE

APPS.FPA_AW_SCE_SUM_CATS_V is not referenced by any database object