[Home] [Help] [Dependency Information]
Object Name: | EDW_BIM_OPPR_OPRNTIES_LTC# |
---|---|
Object Type: | VIEW |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OPPORTUNITY_PK | VARCHAR2 | (240) | ||
OPPORTUNITY_PK_KEY | NUMBER | |||
ALL_FK | VARCHAR2 | (40) | ||
ALL_FK_KEY | NUMBER | |||
OPPORTUNITY_DP | VARCHAR2 | (240) | ||
NAME | VARCHAR2 | (240) | ||
OPPORTUNITY_LEAD_ID | NUMBER | |||
OPP_LEAD_NUMBER | VARCHAR2 | (240) | ||
WIN_PROBABILITY | NUMBER | |||
SALES_STAGE_ID | NUMBER | |||
PRICE_LIST_ID | NUMBER | |||
INITIATING_CONTACT_ID | NUMBER | |||
CLOSE_COMPETITOR_ID | NUMBER | |||
SOURCE_PROMOTION_ID | NUMBER | |||
ADDRESS_ID | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
RANK | VARCHAR2 | (240) | ||
PARENT_PROJECT | VARCHAR2 | (240) | ||
NO_OPP_ALLOWED_FLAG | VARCHAR2 | (40) | ||
LEAD_SOURCE_CODE | VARCHAR2 | (240) | ||
END_USER_CUSTOMER_NAME | VARCHAR2 | (240) | ||
DELETE_ALLOWED_FLAG | VARCHAR2 | (40) | ||
DECISION_DATE_FLAG | VARCHAR2 | (40) | ||
CURRENCY_CODE | VARCHAR2 | (240) | ||
TOTAL_AMOUNT | NUMBER | |||
CLOSE_REASON | VARCHAR2 | (240) | ||
CLOSE_COMPETITOR_CODE | VARCHAR2 | (240) | ||
CLOSE_COMPETITOR | VARCHAR2 | (240) | ||
CLOSE_COMMENT | VARCHAR2 | (240) | ||
CHANNEL_CODE | VARCHAR2 | (80) | ||
DECISION_DATE | DATE | |||
OPP_DESCRIPTION | VARCHAR2 | (2000) | ||
INSTANCE | VARCHAR2 | (40) | ||
USER_ATTRIBUTE1 | VARCHAR2 | (240) | ||
USER_ATTRIBUTE2 | VARCHAR2 | (240) | ||
USER_ATTRIBUTE3 | VARCHAR2 | (240) | ||
USER_ATTRIBUTE4 | VARCHAR2 | (240) | ||
USER_ATTRIBUTE5 | VARCHAR2 | (240) | ||
SECURITY_GROUP_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
CREATION_DATE | DATE | Yes | ||
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | ||
VEHICLE_RESPONSE_CODE | VARCHAR2 | (80) | ||
DECISION_TIMEFRAME_CODE | VARCHAR2 | (80) | ||
DELETED_FLAG | VARCHAR2 | (20) |
Cut, paste (and edit) the following text to query this object:
SELECT OPPORTUNITY_PK
, OPPORTUNITY_PK_KEY
, ALL_FK
, ALL_FK_KEY
, OPPORTUNITY_DP
, NAME
, OPPORTUNITY_LEAD_ID
, OPP_LEAD_NUMBER
, WIN_PROBABILITY
, SALES_STAGE_ID
, PRICE_LIST_ID
, INITIATING_CONTACT_ID
, CLOSE_COMPETITOR_ID
, SOURCE_PROMOTION_ID
, ADDRESS_ID
, CUSTOMER_ID
, RANK
, PARENT_PROJECT
, NO_OPP_ALLOWED_FLAG
, LEAD_SOURCE_CODE
, END_USER_CUSTOMER_NAME
, DELETE_ALLOWED_FLAG
, DECISION_DATE_FLAG
, CURRENCY_CODE
, TOTAL_AMOUNT
, CLOSE_REASON
, CLOSE_COMPETITOR_CODE
, CLOSE_COMPETITOR
, CLOSE_COMMENT
, CHANNEL_CODE
, DECISION_DATE
, OPP_DESCRIPTION
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, SECURITY_GROUP_ID
, LAST_UPDATE_DATE
, CREATION_DATE
, ORIG_SYSTEM_REFERENCE
, VEHICLE_RESPONSE_CODE
, DECISION_TIMEFRAME_CODE
, DELETED_FLAG
FROM BIM.EDW_BIM_OPPR_OPRNTIES_LTC#;
|
|
|