[Home] [Help] [Dependency Information]
Object Name: | EDW_BIM_OSTA_OPPSTATUS_LSTG |
---|---|
Object Type: | TABLE |
Owner: | BIM |
FND Design Data: | BIM.EDW_BIM_OSTA_OPPSTATUS_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_OSTA_OPPSTATUS_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | OPPSTATUS_PK |
EDW_BIM_OSTA_OPPSTATUS_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OPPSTATUS_PK | VARCHAR2 | (240) | Unique Identifier for Opportunity Status . | |
ROW_ID | ROWID | (10) | Row Identifier . | |
OPPSTATUS_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 . | |
ALL_FK | VARCHAR2 | (40) | Foreign Key to All Level in Opportunity Status Dimension . | |
ALL_FK_KEY | NUMBER | System Generated foreign key to All Level in Opportunity Status dimension . | ||
STATUS_CODE | VARCHAR2 | (240) | Opportunity Status Code . | |
MEANING | VARCHAR2 | (240) | Meaning of the Opportunity Status . | |
DESCRIPTION | VARCHAR2 | (240) | Long Description of Opportunity Status . | |
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 . | |
LAST_UPDATE_DATE | DATE | Standard Who Column . | ||
CREATION_DATE | DATE | Standard Who Column . | ||
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 . | ||
OPEN_STATUS_FLAG | VARCHAR2 | (20) | Flag to indicate that this status is for open opportunity . | |
FORECAST_ROLLUP_FLAG | VARCHAR2 | (20) | Flag to indicate opportunity with this status will appear in forecast . | |
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 OPPSTATUS_PK
, ROW_ID
, OPPSTATUS_DP
, NAME
, ALL_FK
, ALL_FK_KEY
, STATUS_CODE
, MEANING
, DESCRIPTION
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, LAST_UPDATE_DATE
, CREATION_DATE
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
, SECURITY_GROUP_ID
, OPEN_STATUS_FLAG
, FORECAST_ROLLUP_FLAG
, WIN_LOSS_INDICATOR
FROM BIM.EDW_BIM_OSTA_OPPSTATUS_LSTG;
BIM.EDW_BIM_OSTA_OPPSTATUS_LSTG does not reference any database object
BIM.EDW_BIM_OSTA_OPPSTATUS_LSTG is referenced by following:
|
|
|