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


TABLE: APPS.DDR_BS_ORDR_ITM_BU_WK_MV

Object Details
Object Name: DDR_BS_ORDR_ITM_BU_WK_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.DDR_BS_ORDR_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_ORDR_ITM_BU FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY 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("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")
DDR_BS_ORDR_ITM_BU_WK_MV_B1 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORG_BSNS_UNIT_ID
DDR_BS_ORDR_ITM_BU_WK_MV_B10 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnBSNS_YR_ID
DDR_BS_ORDR_ITM_BU_WK_MV_B11 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnITM_TYP
DDR_BS_ORDR_ITM_BU_WK_MV_B2 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORG_RGN_ID
DDR_BS_ORDR_ITM_BU_WK_MV_B3 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORG_CHAIN_ID
DDR_BS_ORDR_ITM_BU_WK_MV_B4 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnMFG_ITEM_ID
DDR_BS_ORDR_ITM_BU_WK_MV_B5 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnMFG_ITEM_CLASS_ID
DDR_BS_ORDR_ITM_BU_WK_MV_B6 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnRTL_ITEM_ID
DDR_BS_ORDR_ITM_BU_WK_MV_B7 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnRTL_ITEM_CLASS_ID
DDR_BS_ORDR_ITM_BU_WK_MV_B8 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnBSNS_WK_ID
DDR_BS_ORDR_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)
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
CNT_TOTAL NUMBER

ORDR_QTY_PRMRY NUMBER

ORDR_QTY_ALT NUMBER

ORDR_AMT NUMBER

ORDR_AMT_RPT NUMBER

CNT_ORDR_QTY_PRMRY NUMBER

CNT_ORDR_QTY_ALT NUMBER

CNT_ORDR_AMT NUMBER

CNT_ORDR_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
,      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
,      CNT_TOTAL
,      ORDR_QTY_PRMRY
,      ORDR_QTY_ALT
,      ORDR_AMT
,      ORDR_AMT_RPT
,      CNT_ORDR_QTY_PRMRY
,      CNT_ORDR_QTY_ALT
,      CNT_ORDR_AMT
,      CNT_ORDR_AMT_RPT
FROM APPS.DDR_BS_ORDR_ITM_BU_WK_MV;

Dependencies

[top of page]

APPS.DDR_BS_ORDR_ITM_BU_WK_MV does not reference any database object

APPS.DDR_BS_ORDR_ITM_BU_WK_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_BS_ORDR_ITM_BU_WK_MV
Materialized ViewDDR_SV_ORDR_MV
ViewDDR_SV_ORDR_MV#