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

Object Details

Object Name:	FII_GL_LOCAL_SNAP_F_P_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FII_GL_LOCAL_SNAP_F_P_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	Mandatory	Comments
YEAR_ID	NUMBER	(15)
COST_CENTER_ID	NUMBER	(15)
COMPANY_ID	NUMBER	(15)
FIN_CATEGORY_ID	NUMBER	(15)
FUD1_ID	NUMBER	(15)
FUD2_ID	NUMBER	(15)
LEDGER_ID	NUMBER	(15)
FIN_CAT_TYPE_CODE	VARCHAR2	(30)
G_MONTH1	NUMBER
G_MONTH2	NUMBER
G_MONTH3	NUMBER
G_MONTH4	NUMBER
G_MONTH5	NUMBER
G_MONTH6	NUMBER
G_MONTH7	NUMBER
G_MONTH8	NUMBER
G_MONTH9	NUMBER
G_MONTH10	NUMBER
G_MONTH11	NUMBER
G_MONTH12	NUMBER
G_MONTH13	NUMBER
G_QTR1	NUMBER
G_QTR2	NUMBER
G_QTR3	NUMBER
G_QTR4	NUMBER
G_YEAR	NUMBER
G_MTD	NUMBER
G_QTD	NUMBER
G_YTD	NUMBER
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
AMOUNT_TYPE_CODE	VARCHAR2	(2)		Amount Type Code

Query Text

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


SELECT YEAR_ID
,      COST_CENTER_ID
,      COMPANY_ID
,      FIN_CATEGORY_ID
,      FUD1_ID
,      FUD2_ID
,      LEDGER_ID
,      FIN_CAT_TYPE_CODE
,      G_MONTH1
,      G_MONTH2
,      G_MONTH3
,      G_MONTH4
,      G_MONTH5
,      G_MONTH6
,      G_MONTH7
,      G_MONTH8
,      G_MONTH9
,      G_MONTH10
,      G_MONTH11
,      G_MONTH12
,      G_MONTH13
,      G_QTR1
,      G_QTR2
,      G_QTR3
,      G_QTR4
,      G_YEAR
,      G_MTD
,      G_QTD
,      G_YTD
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      AMOUNT_TYPE_CODE
FROM APPS.FII_GL_LOCAL_SNAP_F_P_V;

Dependencies

[top of page]

APPS.FII_GL_LOCAL_SNAP_F_P_V references the following:

APPS: FII_GL_LOCAL_SNAP_F

APPS.FII_GL_LOCAL_SNAP_F_P_V is not referenced by any database object