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

TABLE: APPS.DDR_SV_ITM_BU_ASSC_MNTH_MV

Object Details
Object Name: DDR_SV_ITM_BU_ASSC_MNTH_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.DDR_SV_ITM_BU_ASSC_MNTH_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_SV_ITM_BU_ASSC1 FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("MFG_ORG_CD")
ColumnSYS_OP_MAP_NONNULL("RTL_ORG_CD")
ColumnSYS_OP_MAP_NONNULL("RTL_BSNS_UNIT_ID")
ColumnSYS_OP_MAP_NONNULL("MFG_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("RTL_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("BSNS_MNTH_ID")
DDR_SV_ITM_BU_ASSC_MNTH_MV_B1 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnRTL_BSNS_UNIT_ID
ColumnMFG_ITEM_ID
ColumnRTL_ITEM_ID
ColumnBSNS_MNTH_ID
DDR_SV_ITM_BU_ASSC_MNTH_MV_B2 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnMFG_ITEM_ID
DDR_SV_ITM_BU_ASSC_MNTH_MV_B3 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnRTL_ITEM_ID
DDR_SV_ITM_BU_ASSC_MNTH_MV_B4 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
RTL_BSNS_UNIT_ID NUMBER
Yes
MFG_ITEM_ID NUMBER
Yes
RTL_ITEM_ID NUMBER
Yes
BSNS_MNTH_ID NUMBER
Yes
TOTAL_BU_ITM_DAYS NUMBER

CNT_WKS NUMBER

CNT_TOTAL NUMBER

Query Text

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


SELECT MFG_ORG_CD
,      RTL_ORG_CD
,      RTL_BSNS_UNIT_ID
,      MFG_ITEM_ID
,      RTL_ITEM_ID
,      BSNS_MNTH_ID
,      TOTAL_BU_ITM_DAYS
,      CNT_WKS
,      CNT_TOTAL
FROM APPS.DDR_SV_ITM_BU_ASSC_MNTH_MV;

Dependencies

[top of page]

APPS.DDR_SV_ITM_BU_ASSC_MNTH_MV does not reference any database object

APPS.DDR_SV_ITM_BU_ASSC_MNTH_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_SV_ITM_BU_ASSC_MNTH_MV
Materialized ViewDDR_SV_ITM_BU_ASSC_QTR_MV
ViewDDR_SV_ITM_BU_ASSC_QTR_MV#