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

VIEW: APPS.CS_NEW_INCIDENTS_V_SEC

Object Details
Object Name: CS_NEW_INCIDENTS_V_SEC
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_NEW_INCIDENTS_V_SEC
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
INCIDENT_ID NUMBER (15) Yes Service request identifier
PROBLEM_CODE VARCHAR2 (50)
Problem code
RESOLUTION_CODE VARCHAR2 (50)
Problem resolution quick code
CUSTOMER_PRODUCT_ID NUMBER (15)
Customer product identifier
INV_ORGANIZATION_ID NUMBER

This field stores the inventory organization id based on the profile AS_PRODUCT_ORGANIZATION_ID.
CP_COMPONENT_ID NUMBER

Identifier for Installed Base Component.
CP_SUBCOMPONENT_ID NUMBER

Identifier for Installed Base Subcomponent.
INVENTORY_ITEM_ID NUMBER (15)
Item identifier
INV_COMPONENT_ID NUMBER

Identifier for the Component for a product not in Installed Base.
INV_COMPONENT_VERSION VARCHAR2 (90)
Identifier for the Component Revision for a product not in Installed Base.
INV_SUBCOMPONENT_ID NUMBER

Identifier for the Subcomponent for a product not in Installed Base.
INV_SUBCOMPONENT_VERSION VARCHAR2 (90)
Identifier for the Subcomponent Revision for a product not in Installed Base.
CURRENT_SERIAL_NUMBER_NV VARCHAR2 (30)
Serial Number for a product that is not in Installed Base
PLATFORM_ID NUMBER

Identifier for Platform.
PLATFORM_VERSION_ID NUMBER

Identifier for Platform Version.
STATUS_CODE VARCHAR2 (90) Yes Status name
INCIDENT_TYPE VARCHAR2 (90) Yes Incident Type name
SEVERITY VARCHAR2 (90) Yes Severity Name
URGENCY VARCHAR2 (90)
Urgency Name
OWNER VARCHAR2 (360)
Service Request Owner's name
COMPANY_NAME VARCHAR2 (360)
Customer Name for whom the Service Request is created
ACCOUNT VARCHAR2 (30)
Account Number
CUSTOMER_ID NUMBER (15)
Customer identifier
CUSTOMER_TICKET_NUMBER VARCHAR2 (50)
Customer's internal helpdesk tracking number.
PERSON_FIRST_NAME VARCHAR2 (150)
Contact person's first name
PERSON_LAST_NAME VARCHAR2 (150)
Contact person's last name
INCIDENT_DATE DATE

Service request date
DATE_CLOSED DATE

Date when the Service Request closed.
PRODUCT_NAME VARCHAR2 (40)
Name of the product
PRODUCT_DESCRIPTION VARCHAR2 (240)
Description for the product
SUMMARY VARCHAR2 (240) Yes Service request summary
Query Text

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


SELECT INCIDENT_ID
,      PROBLEM_CODE
,      RESOLUTION_CODE
,      CUSTOMER_PRODUCT_ID
,      INV_ORGANIZATION_ID
,      CP_COMPONENT_ID
,      CP_SUBCOMPONENT_ID
,      INVENTORY_ITEM_ID
,      INV_COMPONENT_ID
,      INV_COMPONENT_VERSION
,      INV_SUBCOMPONENT_ID
,      INV_SUBCOMPONENT_VERSION
,      CURRENT_SERIAL_NUMBER_NV
,      PLATFORM_ID
,      PLATFORM_VERSION_ID
,      STATUS_CODE
,      INCIDENT_TYPE
,      SEVERITY
,      URGENCY
,      OWNER
,      COMPANY_NAME
,      ACCOUNT
,      CUSTOMER_ID
,      CUSTOMER_TICKET_NUMBER
,      PERSON_FIRST_NAME
,      PERSON_LAST_NAME
,      INCIDENT_DATE
,      DATE_CLOSED
,      PRODUCT_NAME
,      PRODUCT_DESCRIPTION
,      SUMMARY
FROM APPS.CS_NEW_INCIDENTS_V_SEC;

Dependencies

[top of page]

APPS.CS_NEW_INCIDENTS_V_SEC references the following:

SchemaAPPS
ViewCSC_HZ_PARTIES_SELF_V
SynonymCS_HZ_SR_CONTACT_POINTS
SynonymCS_INCIDENTS_ALL_TL
SynonymCS_INCIDENTS_B_SEC
ViewCS_INCIDENT_SEVERITIES_VL
ViewCS_INCIDENT_STATUSES_VL
ViewCS_INCIDENT_TYPES_VL_SEC
ViewCS_INCIDENT_URGENCIES_VL
ViewCS_SR_OWNERS_V
PL/SQL PackageCS_STD - show dependent code
ViewJTF_CUST_ACCOUNTS_ALL_V
ViewJTF_PARTIES_ALL_V
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.CS_NEW_INCIDENTS_V_SEC is not referenced by any database object