[Home] [Help] [Dependency Information]
Object Name: | EDW_BIM_LEAD_LEADS_LSTG |
---|---|
Object Type: | TABLE |
Owner: | BIM |
FND Design Data: | BIM.EDW_BIM_LEAD_LEADS_LSTG |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_BIM_LEAD_LEADS_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | LEAD_PK |
EDW_BIM_LEAD_LEADS_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEAD_PK | VARCHAR2 | (240) | Unique Identifier for Lead . | |
ROW_ID | ROWID | (10) | Row Identifier . | |
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 . | |
SCORECARD_ID | NUMBER | Not Used | ||
TOTAL_SCORE | NUMBER | Total score of this sales lead . | ||
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) | Long 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 | |
REQUEST_ID | NUMBER | Standard Who Column | ||
OPERATION_CODE | VARCHAR2 | (40) | Code used during warehouse collection | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
COLLECTION_STATUS | VARCHAR2 | (40) | Collection status code for the record | |
SECURITY_GROUP_ID | NUMBER | Standard Who Column | ||
DELETED_FLAG | VARCHAR2 | (20) | To indicate this sales lead has been soft deleted. |
Cut, paste (and edit) the following text to query this object:
SELECT LEAD_PK
, ROW_ID
, ALL_FK
, ALL_FK_KEY
, LEAD_DP
, NAME
, SALES_LEAD_ID
, LEAD_NUMBER
, SCORECARD_ID
, TOTAL_SCORE
, 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
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
, SECURITY_GROUP_ID
, DELETED_FLAG
FROM BIM.EDW_BIM_LEAD_LEADS_LSTG;
BIM.EDW_BIM_LEAD_LEADS_LSTG does not reference any database object
BIM.EDW_BIM_LEAD_LEADS_LSTG is referenced by following:
|
|
|