[Home] [Help] [Dependency Information]
Object Name: | BIM_SGMT_ACT_SH_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.BIM_SGMT_ACT_SH_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_BIM_SGMT_ACT_SH_MV | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_SUMMARY |
SYS_OP_MAP_NONNULL("SEGMENT_ID")
SYS_OP_MAP_NONNULL("SOURCE_CODE_ID") SYS_OP_MAP_NONNULL("DUMMY1_FR") SYS_OP_MAP_NONNULL("DUMMY2_FR") SYS_OP_MAP_NONNULL("DUMMY3_FR") SYS_OP_MAP_NONNULL("DUMMY4_FR") SYS_OP_MAP_NONNULL("DUMMY5_FR") SYS_OP_MAP_NONNULL("CATEGORY_ID_C") SYS_OP_MAP_NONNULL("DUMMY6_FR") |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
SEGMENT_ID | NUMBER | |||
SOURCE_CODE_ID | NUMBER | |||
CATEGORY_ID | NUMBER | |||
CATEGORY_ID_C | NUMBER | |||
ACTIVITIES_COUNT | NUMBER | |||
ACTIVITIES_COUNT_C | NUMBER | |||
RESPONSES | NUMBER | |||
RESPONSES_C | NUMBER | |||
LEADS | NUMBER | |||
LEADS_C | NUMBER | |||
NEW_OPPORTUNITY_AMT | NUMBER | |||
NEW_OPPORTUNITY_AMT_C | NUMBER | |||
NEW_OPPORTUNITY_AMT_S | NUMBER | |||
NEW_OPPORTUNITY_AMT_S_C | NUMBER | |||
BOOKED_AMT | NUMBER | |||
BOOKED_AMT_C | NUMBER | |||
BOOKED_AMT_S | NUMBER | |||
BOOKED_AMT_S_C | NUMBER | |||
ALL_CNT | NUMBER | |||
DUMMY1_FR | NUMBER | |||
DUMMY2_FR | NUMBER | |||
DUMMY3_FR | NUMBER | |||
DUMMY4_FR | NUMBER | |||
DUMMY5_FR | NUMBER | |||
DUMMY6_FR | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_ID
, PERIOD_TYPE_ID
, SEGMENT_ID
, SOURCE_CODE_ID
, CATEGORY_ID
, CATEGORY_ID_C
, ACTIVITIES_COUNT
, ACTIVITIES_COUNT_C
, RESPONSES
, RESPONSES_C
, LEADS
, LEADS_C
, NEW_OPPORTUNITY_AMT
, NEW_OPPORTUNITY_AMT_C
, NEW_OPPORTUNITY_AMT_S
, NEW_OPPORTUNITY_AMT_S_C
, BOOKED_AMT
, BOOKED_AMT_C
, BOOKED_AMT_S
, BOOKED_AMT_S_C
, ALL_CNT
, DUMMY1_FR
, DUMMY2_FR
, DUMMY3_FR
, DUMMY4_FR
, DUMMY5_FR
, DUMMY6_FR
FROM APPS.BIM_SGMT_ACT_SH_MV;
APPS.BIM_SGMT_ACT_SH_MV does not reference any database object
APPS.BIM_SGMT_ACT_SH_MV is referenced by following:
|
|
|