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

TABLE: APPS.MLOG$_FII_GL_BASE_MAP2_MV

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

snapshot log for master table APPS.FII_GL_BASE_MAP2_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACTUAL_B NUMBER

ACTUAL_BCT NUMBER

COMPANY_DIM_ID NUMBER (15)
COST_CENTER_DIM_ID NUMBER (15)
CT NUMBER

FIN_CATEGORY_ID NUMBER (15)
FIN_CAT_TYPE_CODE VARCHAR2 (30)
LEDGER_ID NUMBER

PERIOD_TYPE_ID NUMBER

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 CHAR (6)
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
,      COMPANY_DIM_ID
,      COST_CENTER_DIM_ID
,      CT
,      FIN_CATEGORY_ID
,      FIN_CAT_TYPE_CODE
,      LEDGER_ID
,      PERIOD_TYPE_ID
,      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
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_FII_GL_BASE_MAP2_MV;

Dependencies

[top of page]

APPS.MLOG$_FII_GL_BASE_MAP2_MV does not reference any database object

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