[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.FII_GL_LOCAL_SNAP_F_P_V is not referenced by any database object
|
|
|