Skip to content

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

VIEW: APPS.DDR_BS_FRCST_LST_SLS_MV#

Object Details
Object Name: DDR_BS_FRCST_LST_SLS_MV#
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE( INITIAL 16384 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "APPS_TS_SUMMARY"
BUILD DEFERRED
USING INDEX
REFRESH FORCE ON DEMAND
USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE

[View Source]

Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes
RTL_ORG_CD VARCHAR2 (30) Yes
ORG_BSNS_UNIT_ID NUMBER
Yes
MFG_SKU_ITEM_ID NUMBER

RTL_SKU_ITEM_ID NUMBER
Yes
DAY_CD VARCHAR2 (30) Yes
FRCST_PURP VARCHAR2 (30)
FRCST_TYP VARCHAR2 (30) Yes
MAX_FRCST_VRSN DATE

ACT_FRCST_SLS_AMT_RPT NUMBER

ACT_FRCST_SLS_QTY_PRMRY NUMBER

FRCST_ROWID ROWID (10)
MAXVRSN_ROWID ROWID (10)
SLS_ROWID ROWID (10)
Query Text

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


SELECT MFG_ORG_CD
,      RTL_ORG_CD
,      ORG_BSNS_UNIT_ID
,      MFG_SKU_ITEM_ID
,      RTL_SKU_ITEM_ID
,      DAY_CD
,      FRCST_PURP
,      FRCST_TYP
,      MAX_FRCST_VRSN
,      ACT_FRCST_SLS_AMT_RPT
,      ACT_FRCST_SLS_QTY_PRMRY
,      FRCST_ROWID
,      MAXVRSN_ROWID
,      SLS_ROWID
FROM APPS.DDR_BS_FRCST_LST_SLS_MV#;

Dependencies

[top of page]

APPS.DDR_BS_FRCST_LST_SLS_MV# references the following:

SchemaAPPS
TableDDR_BS_FRCST_VRSN_MV
SynonymDDR_B_RTL_SL_RTN_ITM_DAY
SynonymDDR_B_SLS_FRCST_ITEM_DAY

APPS.DDR_BS_FRCST_LST_SLS_MV# is not referenced by any database object