[Home] [Help] [Dependency Information]
Object Name: | CS_INCIDENT_STATUSES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CS.CS_INCIDENT_STATUSES_VL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
MultiLingual view (a language resolved view of the data.)
Multi-lingual view for CS_INCIDENT_STATUSES_B and CS_INCIDENT_STATUSES_TL tables.
.
This view returns one row from the _TL table corresponding to the language specifed in the environment variable 'LANG', for each row in the _B table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | This is the Row ID of MLS base table. | |
INCIDENT_STATUS_ID | NUMBER | (15) | Yes | Status unique identifier |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
INCIDENT_SUBTYPE | VARCHAR2 | (30) | Yes | Identifies whether the status is a service request status or action status. For 11i always 'INC' |
DISPLAY_COLOR | VARCHAR2 | (30) | The name of the Visual attribute used to set the Text color of the urgency field in the Service requests form. Visual attributes can be selected from a predefined set via a color palette form only. | |
RGB_COLOR | VARCHAR2 | (20) | The RGB value of color for use by non-forms clients only | |
START_DATE_ACTIVE | DATE | Date this status becomes active, if limited | ||
END_DATE_ACTIVE | DATE | Date this status becomes inactive, if limited | ||
SEEDED_FLAG | VARCHAR2 | (1) | Flag indicating pre-defined status | |
STATUS_CODE | VARCHAR2 | (32) | Not used | |
CLOSE_FLAG | VARCHAR2 | (1) | Indicates whether service requests having this status are closed | |
VALID_IN_CREATE_FLAG | VARCHAR2 | (3) | This column denotes whether the status can be used in the creation of a Service Request. A value of 'Y' indicates that the status can be used in creation, and 'N' or NULL indicates that the status cannot be used for creation. New for 1159. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
DISALLOW_REQUEST_UPDATE | VARCHAR2 | (1) | Service Request update not allowed | |
DISALLOW_NEW_ACTION | VARCHAR2 | (1) | New Actions not allowed | |
DISALLOW_ACTION_UPDATE | VARCHAR2 | (1) | Action update not allowed. | |
DISALLOW_NEW_CHARGE | VARCHAR2 | (1) | New charges not allowed | |
DISALLOW_AGENT_DISPATCH | VARCHAR2 | (1) | Agent Dispatch not allowed | |
DISALLOW_RMA | VARCHAR2 | (1) | RMA not allowed | |
DISALLOW_CHARGE_UPDATE | VARCHAR2 | (1) | Charges update not allowed | |
DISALLOW_PRODUCT_UPDATE | VARCHAR2 | (1) | For a given status, if this flag is yes ('Y'), do not allow the product to be updatable on the Service Request form. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Sequential number used for database locking control when using HTML as a user interface. | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language of Text. The language to which things are translated. |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Language from which things are translated. |
NAME | VARCHAR2 | (90) | Yes | A name given to Status. |
DESCRIPTION | VARCHAR2 | (720) | This is a description of the Status. | |
SORT_ORDER | NUMBER | The order of the status flow. | ||
RESPONDED_FLAG | VARCHAR2 | (3) | Responded flag | |
RESOLVED_FLAG | VARCHAR2 | (3) | Resolved flag. | |
STATUS_CLASS_CODE | VARCHAR2 | (30) | Status classification code. | |
ON_HOLD_FLAG | VARCHAR2 | (3) | Status Attribute that will indicate if a Service Request is waiting on any other event/action in order to proceed. | |
PENDING_APPROVAL_FLAG | VARCHAR2 | (1) | Status to indicate SR is in ERES process. | |
INTERMEDIATE_STATUS_ID | NUMBER | Incident status id of the status mapped as intermediate status for the target status | ||
REJECTION_ACTION_STATUS_ID | NUMBER | Incident status id of the status mapped as rejection action status for the target status | ||
APPROVAL_ACTION_STATUS_ID | NUMBER | Incident status id of the status mapped as approval action status for the target status |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, INCIDENT_STATUS_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, INCIDENT_SUBTYPE
, DISPLAY_COLOR
, RGB_COLOR
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, SEEDED_FLAG
, STATUS_CODE
, CLOSE_FLAG
, VALID_IN_CREATE_FLAG
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, DISALLOW_REQUEST_UPDATE
, DISALLOW_NEW_ACTION
, DISALLOW_ACTION_UPDATE
, DISALLOW_NEW_CHARGE
, DISALLOW_AGENT_DISPATCH
, DISALLOW_RMA
, DISALLOW_CHARGE_UPDATE
, DISALLOW_PRODUCT_UPDATE
, OBJECT_VERSION_NUMBER
, LANGUAGE
, SOURCE_LANG
, NAME
, DESCRIPTION
, SORT_ORDER
, RESPONDED_FLAG
, RESOLVED_FLAG
, STATUS_CLASS_CODE
, ON_HOLD_FLAG
, PENDING_APPROVAL_FLAG
, INTERMEDIATE_STATUS_ID
, REJECTION_ACTION_STATUS_ID
, APPROVAL_ACTION_STATUS_ID
FROM APPS.CS_INCIDENT_STATUSES_VL;
|
|
|