DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CSL_CS_INCIDENTS_ALL_V

Object Details
Object Name: CSL_CS_INCIDENTS_ALL_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Mobile view on CS_INCIDENTS_ALL_VL


[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCESS_ID NUMBER

identifier to CSL_CS_INCIDENTS_ALL_ACC table
INCIDENT_ID NUMBER (15) Yes Service request identifier
OBJECT_VERSION_NUMBER NUMBER (9)
Sequential number used for database locking control when using HTML as a user interface
CALLER_TYPE VARCHAR2 (30) Yes Type of the Calling Party. It could be an Organization, Person, Employee.
INCIDENT_NUMBER VARCHAR2 (64) Yes Service request number
INCIDENT_SEVERITY_ID NUMBER (15) Yes Identifier for service request severity
INCIDENT_STATUS_ID NUMBER (15) Yes Identifier for service request status
INCIDENT_TYPE_ID NUMBER (15) Yes Identifier for service request type
INCIDENT_URGENCY_ID NUMBER (15)
Identifier for service request urgency
INCIDENT_DATE DATE

Service request date
SUMMARY VARCHAR2 (240) Yes Service request summary
ORG_ID NUMBER

Operating unit identifier
CUSTOMER_ID NUMBER (15)
Customer identifier
INSTALL_SITE_USE_ID NUMBER (15)
Identifier for installed site use
CUSTOMER_PRODUCT_ID NUMBER (15)
Customer product identifier
INVENTORY_ITEM_ID NUMBER (15)
Item identifier
INV_ORGANIZATION_ID NUMBER

This field stores the inventory organization id based on the profile AS_PRODUCT_ORGANIZATION_ID.
PROBLEM_CODE VARCHAR2 (50)
Problem code
RESOLUTION_CODE VARCHAR2 (50)
Problem resolution quick code
CONTRACT_SERVICE_ID NUMBER

Service line unique identifier
CURRENT_SERIAL_NUMBER VARCHAR2 (30)
Product serial number for product not in installed base
INV_ITEM_REVISION VARCHAR2 (240)
Identifier for the Item Revision for a product not in Installed Base.
LANGUAGE VARCHAR2 (4) Yes Language of Text. The language to which things are translated.
INCIDENT_ATTRIBUTE_1 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_2 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_3 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_4 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_5 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_6 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_7 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_8 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_9 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_10 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_11 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_12 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_13 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_14 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_15 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_CONTEXT VARCHAR2 (30)
Descriptive flexfield structure defining column
CUSTOMER_PO_NUMBER VARCHAR2 (50)
Customers Purchase Order number.
LAST_UPDATE_DATE DATE
Yes Standard who column
CREDIT_CARD_NUMBER VARCHAR2 (48)
Encrypted format of the Credit Card Number. Credit card numbers are stored in Base64 format. Service public API's are available to decrypt/encrypt these numbers.
CREDIT_CARD_TYPE_CODE VARCHAR2 (30)
Credit card type. This type code is a lookup code for lookup type CS_CREDIT_CARD_TYPES. The allowed values are Visa,Master Card,Amex,Discover, Enroute and JCB.
CREDIT_CARD_EXPIRATION_DATE DATE

Date of expiration of the Credit Card. The last day of the month is stored as the expiration date.
CREDIT_CARD_HOLDER_FNAME VARCHAR2 (250)
First name on the Credit Card.
CREDIT_CARD_HOLDER_MNAME VARCHAR2 (250)
Middle name on the Credit Card.
CREDIT_CARD_HOLDER_LNAME VARCHAR2 (250)
Last name on the Credit Card.
CREDIT_CARD_ID NUMBER (15)
This column is an FK reference to the ID in the Credit Card Master table. As of 11.5.9 this column is not functionally active.
INSTALL_SITE_ID NUMBER

Identifier for installed site use
OBLIGATION_DATE DATE

Reaction Date specified in the contracts
EXPECTED_RESOLUTION_DATE DATE

Resolution date specified in the contract
INCIDENT_LOCATION_ID NUMBER

Incident Location Id
INCIDENT_ADDRESS VARCHAR2 (960)
Incident Address
INCIDENT_CITY VARCHAR2 (60)
Incident City
INCIDENT_STATE VARCHAR2 (60)
Incident State
INCIDENT_COUNTRY VARCHAR2 (60)
Incident Country
INCIDENT_PROVINCE VARCHAR2 (60)
Province
INCIDENT_POSTAL_CODE VARCHAR2 (60)
Postal Code
INCIDENT_COUNTY VARCHAR2 (60)
County
INCIDENT_LOCATION_TYPE VARCHAR2 (30)
Location Type: Whether Party Site/Location
CONCATENATED_SEGMENTS VARCHAR2 (40)
No Comments
ITEM_DESCRIPTION VARCHAR2 (240)
No Comments
EXTERNAL_ATTRIBUTE_1 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_2 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_3 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_4 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_5 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_6 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_7 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_8 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_9 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_10 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_11 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_12 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_13 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_14 VARCHAR2 (150)
No Comments
EXTERNAL_ATTRIBUTE_15 VARCHAR2 (150)
No Comments
EXTERNAL_CONTEXT VARCHAR2 (30)
No Comments
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCESS_ID
,      INCIDENT_ID
,      OBJECT_VERSION_NUMBER
,      CALLER_TYPE
,      INCIDENT_NUMBER
,      INCIDENT_SEVERITY_ID
,      INCIDENT_STATUS_ID
,      INCIDENT_TYPE_ID
,      INCIDENT_URGENCY_ID
,      INCIDENT_DATE
,      SUMMARY
,      ORG_ID
,      CUSTOMER_ID
,      INSTALL_SITE_USE_ID
,      CUSTOMER_PRODUCT_ID
,      INVENTORY_ITEM_ID
,      INV_ORGANIZATION_ID
,      PROBLEM_CODE
,      RESOLUTION_CODE
,      CONTRACT_SERVICE_ID
,      CURRENT_SERIAL_NUMBER
,      INV_ITEM_REVISION
,      LANGUAGE
,      INCIDENT_ATTRIBUTE_1
,      INCIDENT_ATTRIBUTE_2
,      INCIDENT_ATTRIBUTE_3
,      INCIDENT_ATTRIBUTE_4
,      INCIDENT_ATTRIBUTE_5
,      INCIDENT_ATTRIBUTE_6
,      INCIDENT_ATTRIBUTE_7
,      INCIDENT_ATTRIBUTE_8
,      INCIDENT_ATTRIBUTE_9
,      INCIDENT_ATTRIBUTE_10
,      INCIDENT_ATTRIBUTE_11
,      INCIDENT_ATTRIBUTE_12
,      INCIDENT_ATTRIBUTE_13
,      INCIDENT_ATTRIBUTE_14
,      INCIDENT_ATTRIBUTE_15
,      INCIDENT_CONTEXT
,      CUSTOMER_PO_NUMBER
,      LAST_UPDATE_DATE
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_TYPE_CODE
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_HOLDER_FNAME
,      CREDIT_CARD_HOLDER_MNAME
,      CREDIT_CARD_HOLDER_LNAME
,      CREDIT_CARD_ID
,      INSTALL_SITE_ID
,      OBLIGATION_DATE
,      EXPECTED_RESOLUTION_DATE
,      INCIDENT_LOCATION_ID
,      INCIDENT_ADDRESS
,      INCIDENT_CITY
,      INCIDENT_STATE
,      INCIDENT_COUNTRY
,      INCIDENT_PROVINCE
,      INCIDENT_POSTAL_CODE
,      INCIDENT_COUNTY
,      INCIDENT_LOCATION_TYPE
,      CONCATENATED_SEGMENTS
,      ITEM_DESCRIPTION
,      EXTERNAL_ATTRIBUTE_1
,      EXTERNAL_ATTRIBUTE_2
,      EXTERNAL_ATTRIBUTE_3
,      EXTERNAL_ATTRIBUTE_4
,      EXTERNAL_ATTRIBUTE_5
,      EXTERNAL_ATTRIBUTE_6
,      EXTERNAL_ATTRIBUTE_7
,      EXTERNAL_ATTRIBUTE_8
,      EXTERNAL_ATTRIBUTE_9
,      EXTERNAL_ATTRIBUTE_10
,      EXTERNAL_ATTRIBUTE_11
,      EXTERNAL_ATTRIBUTE_12
,      EXTERNAL_ATTRIBUTE_13
,      EXTERNAL_ATTRIBUTE_14
,      EXTERNAL_ATTRIBUTE_15
,      EXTERNAL_CONTEXT
FROM APPS.CSL_CS_INCIDENTS_ALL_V;

Dependencies

[top of page]

APPS.CSL_CS_INCIDENTS_ALL_V references the following:

SchemaAPPS
PL/SQL PackageASG_BASE - show dependent code
SynonymCSL_CS_INCIDENTS_ALL_ACC
SynonymCS_INCIDENTS_ALL_B
SynonymCS_INCIDENTS_ALL_TL
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.CSL_CS_INCIDENTS_ALL_V is not referenced by any database object