[Home] [Help] [Dependency Information]
Object Name: | EDW_BIM_OPP_STATUS_M |
---|---|
Object Type: | TABLE |
Owner: | BIM |
FND Design Data: | BIM.EDW_BIM_OPP_STATUS_M |
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_OPP_STATUS_M_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
L1_OPPSTATUS_PK
L1_OPPSTATUS_PK_KEY |
EDW_BIM_OPP_STATUS_M_U2 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | L1_OPPSTATUS_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
L1_OPPSTATUS_PK_KEY | NUMBER | Yes | System Generated Unique identifier for opportunity status . | |
L0_ALL_PK_KEY | NUMBER | System Generated unique identifier of the ALL Level . | ||
L0_ALL_PK | VARCHAR2 | (40) | Unique identifier of the All Level . | |
L0_NAME | VARCHAR2 | (80) | Reserved for future use in Express . | |
L1_OPPSTATUS_PK | VARCHAR2 | (240) | Unique Identifier for Opportunity Status . | |
L1_OPPSTATUS_DP | VARCHAR2 | (240) | Field for discoverer so customers can have a display column that identifies all records uniquely . | |
L1_NAME | VARCHAR2 | (240) | Reserved for future use in Express . | |
L1_STATUS_CODE | VARCHAR2 | (240) | Opportunity Status Code . | |
L1_MEANING | VARCHAR2 | (240) | Meaning of the Opportunity Status . | |
L1_DESCRIPTION | VARCHAR2 | (240) | Long Description of Opportunity Status . | |
L1_INSTANCE | VARCHAR2 | (40) | Instance Identifier . | |
L1_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Attribute . | |
L1_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Attribute . | |
L1_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Attribute . | |
L1_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Attribute . | |
L1_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Attribute . | |
L1_LAST_UPDATE_DATE | DATE | Standard Who Column . | ||
L1_CREATION_DATE | DATE | Standard Who Column . | ||
SECURITY_GROUP_ID | NUMBER | Standard Who Column . | ||
LAST_UPDATE_DATE | DATE | Yes | ||
CREATION_DATE | DATE | Yes | ||
L1_OPEN_STATUS_FLAG | VARCHAR2 | (20) | Flag to indicate that this status is for open opportunity . | |
L1_FORECAST_ROLLUP_FLAG | VARCHAR2 | (20) | Flag to indicate opportunity with this status will appear in forecast . | |
L1_WIN_LOSS_INDICATOR | VARCHAR2 | (20) | Indicates whether the opportunity or lead is Won and Closed or Lost and Closed or just Closed because it is not an opportunity anymore. Validation will be made against Open Flag. Possible values are 'W', 'L', 'N' (neither equivalent to NULL) . |
Cut, paste (and edit) the following text to query this object:
SELECT L1_OPPSTATUS_PK_KEY
, L0_ALL_PK_KEY
, L0_ALL_PK
, L0_NAME
, L1_OPPSTATUS_PK
, L1_OPPSTATUS_DP
, L1_NAME
, L1_STATUS_CODE
, L1_MEANING
, L1_DESCRIPTION
, L1_INSTANCE
, L1_USER_ATTRIBUTE1
, L1_USER_ATTRIBUTE2
, L1_USER_ATTRIBUTE3
, L1_USER_ATTRIBUTE4
, L1_USER_ATTRIBUTE5
, L1_LAST_UPDATE_DATE
, L1_CREATION_DATE
, SECURITY_GROUP_ID
, LAST_UPDATE_DATE
, CREATION_DATE
, L1_OPEN_STATUS_FLAG
, L1_FORECAST_ROLLUP_FLAG
, L1_WIN_LOSS_INDICATOR
FROM BIM.EDW_BIM_OPP_STATUS_M;
BIM.EDW_BIM_OPP_STATUS_M does not reference any database object
BIM.EDW_BIM_OPP_STATUS_M is referenced by following:
|
|
|