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

TABLE: APPS.DDR_BS_SLSR_ITM_BU_WK_MV

Object Details
Object Name: DDR_BS_SLSR_ITM_BU_WK_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableDDR.DDR_BS_SLSR_ITM_BU_WK_MV
TableFND.DDR_BS_SLSR_ITM_BU_WK_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_DDR_BS_SLSR_ITM_BU FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnSYS_OP_MAP_NONNULL("BSNS_WK_ID")
ColumnSYS_OP_MAP_NONNULL("BSNS_MNTH_ID")
ColumnSYS_OP_MAP_NONNULL("BSNS_YR_ID")
ColumnSYS_OP_MAP_NONNULL("MFG_ORG_CD")
ColumnSYS_OP_MAP_NONNULL("RTL_ORG_CD")
ColumnSYS_OP_MAP_NONNULL("ORG_BSNS_UNIT_ID")
ColumnSYS_OP_MAP_NONNULL("ITM_TYP")
ColumnSYS_OP_MAP_NONNULL("MKT_AREA_ID")
ColumnSYS_OP_MAP_NONNULL("CHNL_TYP_CD")
ColumnSYS_OP_MAP_NONNULL("ORG_RGN_ID")
ColumnSYS_OP_MAP_NONNULL("ORG_CHAIN_ID")
ColumnSYS_OP_MAP_NONNULL("MFG_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("MFG_ITEM_CLASS_ID")
ColumnSYS_OP_MAP_NONNULL("RTL_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("RTL_ITEM_CLASS_ID")
ColumnSYS_OP_MAP_NONNULL("SLS_TYP_CD")
ColumnSYS_OP_MAP_NONNULL("MFG_PRMTN_ID")
DDR_BS_SLSR_ITM_BU_WK_MV_B1 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORG_BSNS_UNIT_ID
DDR_BS_SLSR_ITM_BU_WK_MV_B10 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnBSNS_YR_ID
DDR_BS_SLSR_ITM_BU_WK_MV_B11 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnMKT_AREA_ID
DDR_BS_SLSR_ITM_BU_WK_MV_B12 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnCHNL_TYP_CD
DDR_BS_SLSR_ITM_BU_WK_MV_B13 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnITM_TYP
DDR_BS_SLSR_ITM_BU_WK_MV_B14 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSLS_TYP_CD
DDR_BS_SLSR_ITM_BU_WK_MV_B15 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnMFG_PRMTN_ID
DDR_BS_SLSR_ITM_BU_WK_MV_B2 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORG_RGN_ID
DDR_BS_SLSR_ITM_BU_WK_MV_B3 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORG_CHAIN_ID
DDR_BS_SLSR_ITM_BU_WK_MV_B4 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnMFG_ITEM_ID
DDR_BS_SLSR_ITM_BU_WK_MV_B5 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnMFG_ITEM_CLASS_ID
DDR_BS_SLSR_ITM_BU_WK_MV_B6 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnRTL_ITEM_ID
DDR_BS_SLSR_ITM_BU_WK_MV_B7 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnRTL_ITEM_CLASS_ID
DDR_BS_SLSR_ITM_BU_WK_MV_B8 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnBSNS_WK_ID
DDR_BS_SLSR_ITM_BU_WK_MV_B9 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnBSNS_MNTH_ID
Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes
RTL_ORG_CD VARCHAR2 (30) Yes
ORG_BSNS_UNIT_ID NUMBER
Yes
ITM_TYP VARCHAR2 (1)
MKT_AREA_ID NUMBER

CHNL_TYP_CD VARCHAR2 (30)
ORG_RGN_ID NUMBER
Yes
ORG_CHAIN_ID NUMBER
Yes
MFG_ITEM_ID NUMBER
Yes
MFG_ITEM_CLASS_ID NUMBER
Yes
RTL_ITEM_ID NUMBER
Yes
RTL_ITEM_CLASS_ID NUMBER
Yes
BSNS_WK_ID NUMBER
Yes
BSNS_MNTH_ID NUMBER
Yes
BSNS_YR_ID NUMBER
Yes
SLS_TYP_CD VARCHAR2 (30)
MFG_PRMTN_ID NUMBER

CNT_TOTAL NUMBER

ACT_BU_ITM_DAYS_SCANNED NUMBER

SLS_QTY_PRMRY NUMBER

SLS_QTY_ALT NUMBER

SLS_AMT NUMBER

SLS_AMT_RPT NUMBER

SLS_COST_AMT NUMBER

SLS_COST_AMT_RPT NUMBER

RTRN_QTY_PRMRY NUMBER

RTRN_QTY_ALT NUMBER

RTRN_AMT NUMBER

RTRN_AMT_RPT NUMBER

RTRN_COST_AMT NUMBER

RTRN_COST_AMT_RPT NUMBER

CNT_SLS_QTY_PRMRY NUMBER

CNT_SLS_QTY_ALT NUMBER

CNT_SLS_AMT NUMBER

CNT_SLS_AMT_RPT NUMBER

CNT_SLS_COST_AMT NUMBER

CNT_SLS_COST_AMT_RPT NUMBER

CNT_RTRN_QTY_PRMRY NUMBER

CNT_RTRN_QTY_ALT NUMBER

CNT_RTRN_AMT NUMBER

CNT_RTRN_AMT_RPT NUMBER

CNT_RTRN_COST_AMT NUMBER

CNT_RTRN_COST_AMT_RPT NUMBER

Query Text

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


SELECT MFG_ORG_CD
,      RTL_ORG_CD
,      ORG_BSNS_UNIT_ID
,      ITM_TYP
,      MKT_AREA_ID
,      CHNL_TYP_CD
,      ORG_RGN_ID
,      ORG_CHAIN_ID
,      MFG_ITEM_ID
,      MFG_ITEM_CLASS_ID
,      RTL_ITEM_ID
,      RTL_ITEM_CLASS_ID
,      BSNS_WK_ID
,      BSNS_MNTH_ID
,      BSNS_YR_ID
,      SLS_TYP_CD
,      MFG_PRMTN_ID
,      CNT_TOTAL
,      ACT_BU_ITM_DAYS_SCANNED
,      SLS_QTY_PRMRY
,      SLS_QTY_ALT
,      SLS_AMT
,      SLS_AMT_RPT
,      SLS_COST_AMT
,      SLS_COST_AMT_RPT
,      RTRN_QTY_PRMRY
,      RTRN_QTY_ALT
,      RTRN_AMT
,      RTRN_AMT_RPT
,      RTRN_COST_AMT
,      RTRN_COST_AMT_RPT
,      CNT_SLS_QTY_PRMRY
,      CNT_SLS_QTY_ALT
,      CNT_SLS_AMT
,      CNT_SLS_AMT_RPT
,      CNT_SLS_COST_AMT
,      CNT_SLS_COST_AMT_RPT
,      CNT_RTRN_QTY_PRMRY
,      CNT_RTRN_QTY_ALT
,      CNT_RTRN_AMT
,      CNT_RTRN_AMT_RPT
,      CNT_RTRN_COST_AMT
,      CNT_RTRN_COST_AMT_RPT
FROM APPS.DDR_BS_SLSR_ITM_BU_WK_MV;

Dependencies

[top of page]

APPS.DDR_BS_SLSR_ITM_BU_WK_MV does not reference any database object

APPS.DDR_BS_SLSR_ITM_BU_WK_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_BS_SLSR_ITM_BU_WK_MV
Materialized ViewDDR_SV_SLSR_MV
ViewDDR_SV_SLSR_MV#