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


TABLE: APPS.BIX_CALL_PRESP_MV

Object Details
Object Name: BIX_CALL_PRESP_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.BIX_CALL_PRESP_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_BIX_CALL_PRESP_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("SOURCE_CODE_ID")
ColumnSYS_OP_MAP_NONNULL("PARTY_ID")
ColumnSYS_OP_MAP_NONNULL("TRANSACTION_CREATE_DATE")
Columns
Name Datatype Length Mandatory Comments
SOURCE_CODE_ID NUMBER

PARTY_ID NUMBER

TRANSACTION_CREATE_DATE DATE
Yes
RESPONSE_COUNT NUMBER

RESPONSE_COUNT_C NUMBER

ALL_COUNT NUMBER

Query Text

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


SELECT SOURCE_CODE_ID
,      PARTY_ID
,      TRANSACTION_CREATE_DATE
,      RESPONSE_COUNT
,      RESPONSE_COUNT_C
,      ALL_COUNT
FROM APPS.BIX_CALL_PRESP_MV;

Dependencies

[top of page]

APPS.BIX_CALL_PRESP_MV does not reference any database object

APPS.BIX_CALL_PRESP_MV is referenced by following:

SchemaAPPS
Materialized ViewBIM_I_EXT_COL_MV
Materialized ViewBIM_SGMT_ACT_B_MV
Materialized ViewBIX_CALL_PRESP_MV