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

TABLE: APPS.MLOG$_FII_GL_BASE_MV

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

snapshot log for master table APPS.FII_GL_BASE_MV

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

ACTUAL_BCT NUMBER

COST_CENTER_ORG_ID NUMBER (15)
CT NUMBER

FIN_CATEGORY_ID NUMBER (15)
FUNCTIONAL_CURRENCY VARCHAR2 (15)
JE_SOURCE VARCHAR2 (25)
LEDGER_ID NUMBER

LINE_OF_BUSINESS_ID NUMBER (15)
MANAGER_ID NUMBER (15)
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

PRODUCT_CATEGORY_ID NUMBER (15)
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
,      COST_CENTER_ORG_ID
,      CT
,      FIN_CATEGORY_ID
,      FUNCTIONAL_CURRENCY
,      JE_SOURCE
,      LEDGER_ID
,      LINE_OF_BUSINESS_ID
,      MANAGER_ID
,      PERIOD_TYPE_ID
,      PRIM_ACTUAL_G
,      PRIM_ACTUAL_GCT
,      PRIM_BUDGET_G
,      PRIM_BUDGET_GCT
,      PRIM_FORECAST_G
,      PRIM_FORECAST_GCT
,      PRODUCT_CATEGORY_ID
,      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_MV;

Dependencies

[top of page]

APPS.MLOG$_FII_GL_BASE_MV does not reference any database object

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