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

TABLE: APPS.MLOG$_FII_GL_MGMT_CCC_MV

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

snapshot log for master table APPS.FII_GL_MGMT_CCC_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)
LINE_OF_BUSINESS_ID NUMBER (15)
MANAGER_ID NUMBER (15)
PARENT_FIN_CATEGORY_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

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

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
,      LINE_OF_BUSINESS_ID
,      MANAGER_ID
,      PARENT_FIN_CATEGORY_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
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_FII_GL_MGMT_CCC_MV;

Dependencies

[top of page]

APPS.MLOG$_FII_GL_MGMT_CCC_MV does not reference any database object

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