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

TABLE: APPS.MLOG$_BIM_LD_CAMP_GH_MV

Object Details
Object Name: MLOG$_BIM_LD_CAMP_GH_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

snapshot log for master table APPS.BIM_LD_CAMP_GH_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER

LEADS NUMBER

LEADS_CHANGED NUMBER

LEADS_CLOSED NUMBER

LEADS_CONVERTED NUMBER

LEADS_DEAD NUMBER

LEADS_NEW NUMBER

LEADS_OPEN NUMBER

LEADS_QUALIFIED NUMBER

LEADS_QUALIFIED_A NUMBER

LEAD_AMOUNT NUMBER

LEAD_CONVERTED_DATE DATE

LEAD_CREATION_DATE DATE

ORDERS_BOOKED_AMT NUMBER

ORDERS_INVOICED_AMT NUMBER

RANK_A NUMBER

RANK_B NUMBER

RANK_C NUMBER

RANK_D NUMBER

RANK_Z NUMBER

RESOURCE_ID NUMBER

SOURCE_CODE_ID NUMBER

TRANSACTION_CREATE_DATE DATE

M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
Query Text

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


SELECT GROUP_ID
,      LEADS
,      LEADS_CHANGED
,      LEADS_CLOSED
,      LEADS_CONVERTED
,      LEADS_DEAD
,      LEADS_NEW
,      LEADS_OPEN
,      LEADS_QUALIFIED
,      LEADS_QUALIFIED_A
,      LEAD_AMOUNT
,      LEAD_CONVERTED_DATE
,      LEAD_CREATION_DATE
,      ORDERS_BOOKED_AMT
,      ORDERS_INVOICED_AMT
,      RANK_A
,      RANK_B
,      RANK_C
,      RANK_D
,      RANK_Z
,      RESOURCE_ID
,      SOURCE_CODE_ID
,      TRANSACTION_CREATE_DATE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_BIM_LD_CAMP_GH_MV;

Dependencies

[top of page]

APPS.MLOG$_BIM_LD_CAMP_GH_MV does not reference any database object

APPS.MLOG$_BIM_LD_CAMP_GH_MV is not referenced by any database object