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

TABLE: BIM.EDW_BIM_LEAD_LEADS_LTC

Object Details
Object Name: EDW_BIM_LEAD_LEADS_LTC
Object Type: TABLE
Owner: BIM
FND Design Data: TableBIM.EDW_BIM_LEAD_LEADS_LTC
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_BIM_LEAD_LEADS_LTC_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnLEAD_PK_KEY
EDW_BIM_LEAD_LEADS_LTC_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnALL_FK_KEY
Columns
Name Datatype Length Mandatory Comments
LEAD_PK VARCHAR2 (240)
Unique Identifier for Lead .
LEAD_PK_KEY NUMBER

System Generated Unique Identifier for Lead .
ALL_FK VARCHAR2 (40)
Foreign Key to All Level in Lead Dimension .
ALL_FK_KEY NUMBER

System Generated Foreign Key to All Level in Lead Dimension .
LEAD_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely
NAME VARCHAR2 (240)
Reserved for future use in Express .
SALES_LEAD_ID NUMBER

OLTP Unique Identifier for Sales Lead .
LEAD_NUMBER VARCHAR2 (240)
Unique number assigned to lead .
TOTAL_SCORE NUMBER

Total score of this sales lead .
SCORECARD_ID NUMBER

Not Used
BUDGET_AMOUNT NUMBER

Budget Amount for the Lead
ASSIGN_TO_PERSON_ID NUMBER

Not Used
ASSIGN_DATE DATE

Not Used
INITIATING_CONTACT_ID NUMBER

Not Used
SOURCE_PROMOTION_ID NUMBER

Not Used
CUSTOMER_ID NUMBER

Not Used
ADDRESS_ID NUMBER

Not Used
VEHICLE_RESPONSE_CODE VARCHAR2 (240)
Indicates how the lead was created
URGENT_FLAG VARCHAR2 (40)
Not Used
PARENT_PROJECT VARCHAR2 (240)
Parent project of this sales lead
LEAD_RANK_CODE VARCHAR2 (240)
Not Used
KEEP_FLAG VARCHAR2 (40)
Not Used
IMPORT_FLAG VARCHAR2 (40)
Not Used
DECISION_TIMEFRAME_CODE VARCHAR2 (240)
Specifies the time by when decision will be made
CURRENCY_CODE VARCHAR2 (240)
The currency code used for this lead .
CLOSE_REASON VARCHAR2 (240)
Not Used
BUDGET_STATUS_CODE VARCHAR2 (240)
Budget status , validated values are APPROVED, NOT APPROVED and PENDING
ACCEPT_FLAG VARCHAR2 (40)
Not Used
CONTACT_ROLE_CODE VARCHAR2 (80)
Not Used
ORIG_SYSTEM_REFERENCE VARCHAR2 (320)
Identifies the source of sales lead - MKT,ISTORE
LEAD_DESCRIPTION VARCHAR2 (2000)
Description of the Lead
INSTANCE VARCHAR2 (40)
Instance Identifier
USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute
SECURITY_GROUP_ID NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
DELETED_FLAG VARCHAR2 (20)
To indicate this sales lead has been soft deleted.
Query Text

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


SELECT LEAD_PK
,      LEAD_PK_KEY
,      ALL_FK
,      ALL_FK_KEY
,      LEAD_DP
,      NAME
,      SALES_LEAD_ID
,      LEAD_NUMBER
,      TOTAL_SCORE
,      SCORECARD_ID
,      BUDGET_AMOUNT
,      ASSIGN_TO_PERSON_ID
,      ASSIGN_DATE
,      INITIATING_CONTACT_ID
,      SOURCE_PROMOTION_ID
,      CUSTOMER_ID
,      ADDRESS_ID
,      VEHICLE_RESPONSE_CODE
,      URGENT_FLAG
,      PARENT_PROJECT
,      LEAD_RANK_CODE
,      KEEP_FLAG
,      IMPORT_FLAG
,      DECISION_TIMEFRAME_CODE
,      CURRENCY_CODE
,      CLOSE_REASON
,      BUDGET_STATUS_CODE
,      ACCEPT_FLAG
,      CONTACT_ROLE_CODE
,      ORIG_SYSTEM_REFERENCE
,      LEAD_DESCRIPTION
,      INSTANCE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      SECURITY_GROUP_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      DELETED_FLAG
FROM BIM.EDW_BIM_LEAD_LEADS_LTC;

Dependencies

[top of page]

BIM.EDW_BIM_LEAD_LEADS_LTC does not reference any database object

BIM.EDW_BIM_LEAD_LEADS_LTC is referenced by following:

SchemaAPPS
SynonymEDW_BIM_LEAD_LEADS_LTC