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

TABLE: APPS.MLOG$_MTH_ENTITY_PLANNED_U3

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

snapshot log for master table APPS.MTH_ENTITY_PLANNED_USAGE_SM_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ALLOCATED_PLANNED_USAGE NUMBER

AVERAGE_PLANNED_COST NUMBER

DAY DATE

DAY_ID NUMBER

EFFECTIVE_DATE DATE

ENTITY_FK_KEY NUMBER

EXPIRATION_DATE DATE

FISCAL_QUARTER_ID NUMBER

FISCAL_QUARTER_NAME VARCHAR2 (25)
FISCAL_WEEK_ID NUMBER

FISCAL_WEEK_NAME VARCHAR2 (25)
FISCAL_YEAR_ID NUMBER

FISCAL_YEAR_NAME VARCHAR2 (25)
PERIOD_PROFILE VARCHAR2 (7)
PLANNED_USAGE NUMBER

PLANT_FK_KEY NUMBER

SITE_SUSTAIN_FK_KEY NUMBER

SUSTAIN_ASPECT_FK_KEY NUMBER

USAGE_UOM VARCHAR2 (30)
M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
XID$$ NUMBER

Query Text

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


SELECT ALLOCATED_PLANNED_USAGE
,      AVERAGE_PLANNED_COST
,      DAY
,      DAY_ID
,      EFFECTIVE_DATE
,      ENTITY_FK_KEY
,      EXPIRATION_DATE
,      FISCAL_QUARTER_ID
,      FISCAL_QUARTER_NAME
,      FISCAL_WEEK_ID
,      FISCAL_WEEK_NAME
,      FISCAL_YEAR_ID
,      FISCAL_YEAR_NAME
,      PERIOD_PROFILE
,      PLANNED_USAGE
,      PLANT_FK_KEY
,      SITE_SUSTAIN_FK_KEY
,      SUSTAIN_ASPECT_FK_KEY
,      USAGE_UOM
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
,      XID$$
FROM APPS.MLOG$_MTH_ENTITY_PLANNED_U3;

Dependencies

[top of page]

APPS.MLOG$_MTH_ENTITY_PLANNED_U3 does not reference any database object

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