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: APPS.MLOG$_FII_GL_BASE_MAP_MV

Object Details

Object Name:	MLOG$_FII_GL_BASE_MAP_MV
Object Type:	TABLE
Owner:	APPS
Subobject Name:
Status:	VALID

snapshot log for master table APPS.FII_GL_BASE_MAP_MV

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	60
PCT Used:

Columns

Name	Datatype	Length
ACTUAL_B	NUMBER
ACTUAL_BCT	NUMBER
BASELINE_AMOUNT_PRIM	NUMBER
BASELINE_AMOUNT_PRIMCT	NUMBER
BUDGET_VERSION_DATE	DATE
COMMITTED_AMOUNT_PRIM	NUMBER
COMMITTED_AMOUNT_PRIMCT	NUMBER
COMPANY_DIM_ID	NUMBER	(15)
COST_CENTER_DIM_ID	NUMBER	(15)
CT	NUMBER
FIN_CATEGORY_ID	NUMBER	(15)
LEDGER_ID	NUMBER
OBLIGATED_AMOUNT_PRIM	NUMBER
OBLIGATED_AMOUNT_PRIMCT	NUMBER
OTHER_AMOUNT_PRIM	NUMBER
OTHER_AMOUNT_PRIMCT	NUMBER
PERIOD_TYPE_ID	NUMBER
POSTED_DATE	DATE
PRIM_ACTUAL_G	NUMBER
PRIM_ACTUAL_GCT	NUMBER
PRIM_BUDGET_G	NUMBER
PRIM_BUDGET_GCT	NUMBER
PRIM_FORECAST_G	NUMBER
PRIM_FORECAST_GCT	NUMBER
SEC_ACTUAL_G	NUMBER
SEC_ACTUAL_GCT	NUMBER
SEC_BUDGET_G	NUMBER
SEC_BUDGET_GCT	NUMBER
SEC_FORECAST_G	NUMBER
SEC_FORECAST_GCT	NUMBER
TIME_ID	NUMBER
UMARKER	VARCHAR2	(6)
USER_DIM1_ID	NUMBER	(15)
USER_DIM2_ID	NUMBER	(15)
M_ROW$$	VARCHAR2	(255)
SEQUENCE$$	NUMBER
SNAPTIME$$	DATE
DMLTYPE$$	VARCHAR2	(1)
OLD_NEW$$	VARCHAR2	(1)
CHANGE_VECTOR$$	RAW	(255)

Query Text

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


SELECT ACTUAL_B
,      ACTUAL_BCT
,      BASELINE_AMOUNT_PRIM
,      BASELINE_AMOUNT_PRIMCT
,      BUDGET_VERSION_DATE
,      COMMITTED_AMOUNT_PRIM
,      COMMITTED_AMOUNT_PRIMCT
,      COMPANY_DIM_ID
,      COST_CENTER_DIM_ID
,      CT
,      FIN_CATEGORY_ID
,      LEDGER_ID
,      OBLIGATED_AMOUNT_PRIM
,      OBLIGATED_AMOUNT_PRIMCT
,      OTHER_AMOUNT_PRIM
,      OTHER_AMOUNT_PRIMCT
,      PERIOD_TYPE_ID
,      POSTED_DATE
,      PRIM_ACTUAL_G
,      PRIM_ACTUAL_GCT
,      PRIM_BUDGET_G
,      PRIM_BUDGET_GCT
,      PRIM_FORECAST_G
,      PRIM_FORECAST_GCT
,      SEC_ACTUAL_G
,      SEC_ACTUAL_GCT
,      SEC_BUDGET_G
,      SEC_BUDGET_GCT
,      SEC_FORECAST_G
,      SEC_FORECAST_GCT
,      TIME_ID
,      UMARKER
,      USER_DIM1_ID
,      USER_DIM2_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_FII_GL_BASE_MAP_MV;

Dependencies

[top of page]

APPS.MLOG$_FII_GL_BASE_MAP_MV does not reference any database object

APPS.MLOG$_FII_GL_BASE_MAP_MV is not referenced by any database object