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]

TABLE: FII.FII_PSI_PMV_GT

Object Details

Object Name:	FII_PSI_PMV_GT
Object Type:	TABLE
Owner:	FII
Subobject Name:
Status:	VALID

Temporary Table Details

FII.FII_PSI_PMV_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
VIEWBY	VARCHAR2	(240)
VIEWBYID	VARCHAR2	(240)
SORT_ORDER	NUMBER
FII_PSI_AVAIL_C	NUMBER
FII_PSI_PRIOR_AVAIL_C	NUMBER
FII_PSI_GT_AVAIL_C	NUMBER
FII_PSI_GT_PRIOR_AVAIL_C	NUMBER
FII_PSI_PCNT_AVAIL_C	NUMBER
FII_PSI_PRIOR_PCNT_AVAIL_C	NUMBER
FII_PSI_GT_PCNT_AVAIL_C	NUMBER
FII_PSI_GT_PRIOR_PCNT_AVAIL_C	NUMBER
FII_PSI_BUDGET_C	NUMBER
FII_PSI_PRIOR_BUDGET_C	NUMBER
FII_PSI_GT_BUDGET_C	NUMBER
FII_PSI_GT_PRIOR_BUDGET_C	NUMBER
FII_PSI_ENCUMBRANCES_C	NUMBER
FII_PSI_PRIOR_ENCUMBRANCES_C	NUMBER
FII_PSI_GT_ENCUMBRANCES_C	NUMBER
FII_PSI_GT_PRIOR_ENCUM_C	NUMBER
FII_PSI_COMMITTED_C_KPI	NUMBER
FII_PSI_PRIOR_COMMITTED_C	NUMBER
FII_PSI_GT_COMMITTED_C_KPI	NUMBER
FII_PSI_GT_PRIOR_COMMITTED_C	NUMBER
FII_PSI_OBLIGATED_C_KPI	NUMBER
FII_PSI_PRIOR_OBLIGATED_C	NUMBER
FII_PSI_GT_OBLIGATED_C_KPI	NUMBER
FII_PSI_GT_PRIOR_OBLIGATED_C	NUMBER
FII_PSI_OTHERS_C_KPI	NUMBER
FII_PSI_PRIOR_OTHERS_C	NUMBER
FII_PSI_GT_OTHERS_C_KPI	NUMBER
FII_PSI_GT_PRIOR_OTHERS_C	NUMBER
FII_PSI_ACTUALS_C	NUMBER
FII_PSI_PRIOR_ACTUALS_C	NUMBER
FII_PSI_GT_ACTUALS_C	NUMBER
FII_PSI_GT_PRIOR_ACTUALS_C	NUMBER
FII_PSI_BUDGET_A	NUMBER
FII_PSI_ENCUMBRANCES_A	NUMBER
FII_PSI_ACTUALS_A	NUMBER
FII_PSI_GT_BUDGET_A	NUMBER
FII_PSI_GT_ENCUMBRANCES_A	NUMBER
FII_PSI_GT_ACTUALS_A	NUMBER
FII_PSI_COMP_DRILL	VARCHAR2	(240)
FII_PSI_CC_DRILL	VARCHAR2	(240)
FII_PSI_CAT_DRILL	VARCHAR2	(240)
FII_PSI_PROJECT_DRILL	VARCHAR2	(240)
FII_PSI_UD2_DRILL	VARCHAR2	(240)

Query Text

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


SELECT VIEWBY
,      VIEWBYID
,      SORT_ORDER
,      FII_PSI_AVAIL_C
,      FII_PSI_PRIOR_AVAIL_C
,      FII_PSI_GT_AVAIL_C
,      FII_PSI_GT_PRIOR_AVAIL_C
,      FII_PSI_PCNT_AVAIL_C
,      FII_PSI_PRIOR_PCNT_AVAIL_C
,      FII_PSI_GT_PCNT_AVAIL_C
,      FII_PSI_GT_PRIOR_PCNT_AVAIL_C
,      FII_PSI_BUDGET_C
,      FII_PSI_PRIOR_BUDGET_C
,      FII_PSI_GT_BUDGET_C
,      FII_PSI_GT_PRIOR_BUDGET_C
,      FII_PSI_ENCUMBRANCES_C
,      FII_PSI_PRIOR_ENCUMBRANCES_C
,      FII_PSI_GT_ENCUMBRANCES_C
,      FII_PSI_GT_PRIOR_ENCUM_C
,      FII_PSI_COMMITTED_C_KPI
,      FII_PSI_PRIOR_COMMITTED_C
,      FII_PSI_GT_COMMITTED_C_KPI
,      FII_PSI_GT_PRIOR_COMMITTED_C
,      FII_PSI_OBLIGATED_C_KPI
,      FII_PSI_PRIOR_OBLIGATED_C
,      FII_PSI_GT_OBLIGATED_C_KPI
,      FII_PSI_GT_PRIOR_OBLIGATED_C
,      FII_PSI_OTHERS_C_KPI
,      FII_PSI_PRIOR_OTHERS_C
,      FII_PSI_GT_OTHERS_C_KPI
,      FII_PSI_GT_PRIOR_OTHERS_C
,      FII_PSI_ACTUALS_C
,      FII_PSI_PRIOR_ACTUALS_C
,      FII_PSI_GT_ACTUALS_C
,      FII_PSI_GT_PRIOR_ACTUALS_C
,      FII_PSI_BUDGET_A
,      FII_PSI_ENCUMBRANCES_A
,      FII_PSI_ACTUALS_A
,      FII_PSI_GT_BUDGET_A
,      FII_PSI_GT_ENCUMBRANCES_A
,      FII_PSI_GT_ACTUALS_A
,      FII_PSI_COMP_DRILL
,      FII_PSI_CC_DRILL
,      FII_PSI_CAT_DRILL
,      FII_PSI_PROJECT_DRILL
,      FII_PSI_UD2_DRILL
FROM FII.FII_PSI_PMV_GT;

Dependencies

[top of page]

FII.FII_PSI_PMV_GT does not reference any database object

FII.FII_PSI_PMV_GT is referenced by following:

APPS: FII_PSI_PMV_GT