[Home] [Help] [Dependency Information]
Object Name: | BIM_SGMT_ACT_B_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.BIM_SGMT_ACT_B_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UMARK | NUMBER | |||
SEGMENT_ID | NUMBER | |||
ACTIVITY_ID | NUMBER | |||
SCHEDULE_PURPOSE | VARCHAR2 | (240) | ||
CATEGORY_ID | NUMBER | |||
SOURCE_CODE_ID | NUMBER | |||
TRANSACTION_CREATE_DATE | DATE | |||
ACTIVITIES_COUNT | NUMBER | |||
RESPONSES | NUMBER | |||
RESP_CNT | NUMBER | |||
LEADS | 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 | |||
COUNT_ALL | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT UMARK
, SEGMENT_ID
, ACTIVITY_ID
, SCHEDULE_PURPOSE
, CATEGORY_ID
, SOURCE_CODE_ID
, TRANSACTION_CREATE_DATE
, ACTIVITIES_COUNT
, RESPONSES
, RESP_CNT
, LEADS
, 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
, COUNT_ALL
FROM APPS.BIM_SGMT_ACT_B_MV;
APPS.BIM_SGMT_ACT_B_MV does not reference any database object
APPS.BIM_SGMT_ACT_B_MV is referenced by following:
|
|
|