eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: CSL.CSL_CS_INCIDENTS_ALL_VL_INQ#

Object Details

Object Name:	CSL_CS_INCIDENTS_ALL_VL_INQ#
Object Type:	VIEW
Owner:	CSL
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
CLID$$CS	VARCHAR2	(240)
INCIDENT_ID	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(9)
CALLER_TYPE	VARCHAR2	(30)
INCIDENT_NUMBER	VARCHAR2	(64)
INCIDENT_SEVERITY_ID	NUMBER	(15)
INCIDENT_STATUS_ID	NUMBER	(15)
INCIDENT_TYPE_ID	NUMBER	(15)
INCIDENT_URGENCY_ID	NUMBER	(15)
INCIDENT_DATE	DATE
SUMMARY	VARCHAR2	(240)
ORG_ID	NUMBER
CUSTOMER_ID	NUMBER	(15)
INSTALL_SITE_USE_ID	NUMBER	(15)
CUSTOMER_PRODUCT_ID	NUMBER	(15)
INVENTORY_ITEM_ID	NUMBER	(15)
INV_ORGANIZATION_ID	NUMBER
PROBLEM_CODE	VARCHAR2	(50)
RESOLUTION_CODE	VARCHAR2	(50)
CONTRACT_SERVICE_ID	NUMBER
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)
INV_ITEM_REVISION	VARCHAR2	(240)
LANGUAGE	VARCHAR2	(4)
INCIDENT_ATTRIBUTE_1	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_2	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_3	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_4	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_5	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_6	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_7	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_8	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_9	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_10	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_11	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_12	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_13	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_14	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_15	VARCHAR2	(150)
INCIDENT_CONTEXT	VARCHAR2	(30)
CUSTOMER_PO_NUMBER	VARCHAR2	(50)
LAST_UPDATE_DATE	DATE
DMLTYPE$$	VARCHAR2	(1)
SEQNO$$	NUMBER	(10)
TRANID$$	NUMBER	(10)
VERSION$$	NUMBER	(10)
CREDIT_CARD_NUMBER	VARCHAR2	(48)
CREDIT_CARD_TYPE_CODE	VARCHAR2	(30)
CREDIT_CARD_EXPIRATION_DATE	DATE
CREDIT_CARD_HOLDER_FNAME	VARCHAR2	(250)
CREDIT_CARD_HOLDER_MNAME	VARCHAR2	(250)
CREDIT_CARD_HOLDER_LNAME	VARCHAR2	(250)
CREDIT_CARD_ID	NUMBER
INSTALL_SITE_ID	NUMBER
OBLIGATION_DATE	DATE
EXPECTED_RESOLUTION_DATE	DATE
INCIDENT_LOCATION_ID	NUMBER
INCIDENT_ADDRESS	VARCHAR2	(960)
INCIDENT_CITY	VARCHAR2	(60)
INCIDENT_STATE	VARCHAR2	(60)
INCIDENT_COUNTRY	VARCHAR2	(60)
INCIDENT_PROVINCE	VARCHAR2	(60)
INCIDENT_POSTAL_CODE	VARCHAR2	(60)
INCIDENT_COUNTY	VARCHAR2	(60)
INCIDENT_LOCATION_TYPE	VARCHAR2	(30)
CONCATENATED_SEGMENTS	VARCHAR2	(40)
ITEM_DESCRIPTION	VARCHAR2	(240)
EXTERNAL_ATTRIBUTE_1	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_2	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_3	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_4	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_5	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_6	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_7	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_8	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_9	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_10	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_11	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_12	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_13	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_14	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_15	VARCHAR2	(150)
EXTERNAL_CONTEXT	VARCHAR2	(30)

Query Text

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


SELECT CLID$$CS
,      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
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
,      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 CSL.CSL_CS_INCIDENTS_ALL_VL_INQ#;

Dependencies

[top of page]

CSL.CSL_CS_INCIDENTS_ALL_VL_INQ# references the following:

CSL: CSL_CS_INCIDENTS_ALL_VL_INQ

CSL.CSL_CS_INCIDENTS_ALL_VL_INQ# is referenced by following:

APPS: CSL_CS_INCIDENTS_ALL_VL_INQ