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

TABLE: APPS.BIM_I_LP_AGE_SG_MV

Object Details
Object Name: BIM_I_LP_AGE_SG_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_I_LP_AGE_SG_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnGROUP_ID
ColumnRESOURCE_ID
ColumnPRODUCT_CATEGORY_ID
ColumnUMARK
ColumnDIM_ID
Columns
Name Datatype Length Mandatory Comments
UMARK NUMBER

GROUP_ID NUMBER

RESOURCE_ID NUMBER

PRODUCT_CATEGORY_ID NUMBER

CHANNEL_CODE VARCHAR2 (30)
CUST_CATEGORY VARCHAR2 (30)
LEAD_RANK_ID NUMBER

LEAD_SOURCE VARCHAR2 (30)
LEAD_COUNTRY VARCHAR2 (30)
ITEM_ID VARCHAR2 (25)
ORGANIZATION_ID NUMBER

DIM_ID VARCHAR2 (7)
AGE_3_BELOW NUMBER

AGE_3_TO_7 NUMBER

AGE_8_TO_14 NUMBER

AGE_15_TO_21 NUMBER

AGE_22_TO_28 NUMBER

AGE_29_TO_35 NUMBER

AGE_36_TO_42 NUMBER

AGE_42_TO_ABOVE NUMBER

C_DAYS NUMBER

P_DAYS NUMBER

C_LEADS_OPEN NUMBER

P_LEADS_OPEN NUMBER

C_ADAYS NUMBER

P_ADAYS NUMBER

C_ALEADS_OPEN NUMBER

P_ALEADS_OPEN NUMBER

Query Text

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


SELECT UMARK
,      GROUP_ID
,      RESOURCE_ID
,      PRODUCT_CATEGORY_ID
,      CHANNEL_CODE
,      CUST_CATEGORY
,      LEAD_RANK_ID
,      LEAD_SOURCE
,      LEAD_COUNTRY
,      ITEM_ID
,      ORGANIZATION_ID
,      DIM_ID
,      AGE_3_BELOW
,      AGE_3_TO_7
,      AGE_8_TO_14
,      AGE_15_TO_21
,      AGE_22_TO_28
,      AGE_29_TO_35
,      AGE_36_TO_42
,      AGE_42_TO_ABOVE
,      C_DAYS
,      P_DAYS
,      C_LEADS_OPEN
,      P_LEADS_OPEN
,      C_ADAYS
,      P_ADAYS
,      C_ALEADS_OPEN
,      P_ALEADS_OPEN
FROM APPS.BIM_I_LP_AGE_SG_MV;

Dependencies

[top of page]

APPS.BIM_I_LP_AGE_SG_MV does not reference any database object

APPS.BIM_I_LP_AGE_SG_MV is referenced by following:

SchemaAPPS
Materialized ViewBIM_I_LP_AGE_SG_MV