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

TABLE: APPS.MLOG$_DDR_BS_FRCST_ITM_BU_

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

snapshot log for master table APPS.DDR_BS_FRCST_ITM_BU_WK_MV

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

ACT_FRCST_SLS_QTY_PRMRY NUMBER

BSNS_MNTH_ID NUMBER

BSNS_WK_ID NUMBER

BSNS_YR_ID NUMBER

FRCST_SLS_AMT NUMBER

FRCST_SLS_AMT_RPT NUMBER

FRCST_SLS_QTY_ALT NUMBER

FRCST_SLS_QTY_PRMRY NUMBER

ITM_TYP VARCHAR2 (1)
MFG_ITEM_CLASS_ID NUMBER

MFG_ITEM_ID NUMBER

MFG_ORG_CD VARCHAR2 (30)
ORG_BSNS_UNIT_ID NUMBER

ORG_CHAIN_ID NUMBER

ORG_RGN_ID NUMBER

RTL_ITEM_CLASS_ID NUMBER

RTL_ITEM_ID NUMBER

RTL_ORG_CD VARCHAR2 (30)
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 ACT_FRCST_SLS_AMT_RPT
,      ACT_FRCST_SLS_QTY_PRMRY
,      BSNS_MNTH_ID
,      BSNS_WK_ID
,      BSNS_YR_ID
,      FRCST_SLS_AMT
,      FRCST_SLS_AMT_RPT
,      FRCST_SLS_QTY_ALT
,      FRCST_SLS_QTY_PRMRY
,      ITM_TYP
,      MFG_ITEM_CLASS_ID
,      MFG_ITEM_ID
,      MFG_ORG_CD
,      ORG_BSNS_UNIT_ID
,      ORG_CHAIN_ID
,      ORG_RGN_ID
,      RTL_ITEM_CLASS_ID
,      RTL_ITEM_ID
,      RTL_ORG_CD
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_DDR_BS_FRCST_ITM_BU_;

Dependencies

[top of page]

APPS.MLOG$_DDR_BS_FRCST_ITM_BU_ does not reference any database object

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