[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CS_INCIDENTS_ALL_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CS.CS_INCIDENTS_ALL_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.)
This view shows all service requests and their corresponding attributes from CS_INCIDENTS_ALL_B and CS_INCIDENTS_ALL_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) | Row Id | |
| INCIDENT_ID | NUMBER | (15) | Yes | Service request identifier |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| INCIDENT_NUMBER | VARCHAR2 | (64) | Yes | Service request number stored a number |
| INCIDENT_DATE | DATE | Date of the Service request. | ||
| 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_SEVERITY_ID | NUMBER | (15) | Yes | Identifier for service request severity |
| INCIDENT_OWNER_ID | NUMBER | (15) | Identifier for the owner of the service request | |
| RESOURCE_TYPE | VARCHAR2 | (30) | Identifier for the owner type of the service request. The owner type could be an Employee, a Group or a Team. | |
| RESOURCE_SUBTYPE_ID | NUMBER | Not Used. | ||
| INVENTORY_ITEM_ID | NUMBER | (15) | Item identifier | |
| CUSTOMER_ID | NUMBER | (15) | Customer identifier | |
| ACCOUNT_ID | NUMBER | Account Identifier | ||
| BILL_TO_SITE_USE_ID | NUMBER | (15) | Identifier for bill- to site use | |
| PURCHASE_ORDER_NUM | VARCHAR2 | (50) | Purchase order Number. | |
| EMPLOYEE_ID | NUMBER | (15) | Identifier for the employee if the service request is made by an employee | |
| FILED_BY_EMPLOYEE_FLAG | VARCHAR2 | (1) | Flag indicating if the SR was filed by an employee. | |
| SHIP_TO_SITE_USE_ID | NUMBER | (15) | Identifier for ship- to site use | |
| PROBLEM_CODE | VARCHAR2 | (50) | Problem code | |
| EXPECTED_RESOLUTION_DATE | DATE | Expected date for the problem resolution | ||
| ACTUAL_RESOLUTION_DATE | DATE | Actual date of resolution | ||
| CUSTOMER_PRODUCT_ID | NUMBER | (15) | Customer product identifier | |
| INSTALL_SITE_USE_ID | NUMBER | (15) | Identifier for installed site use | |
| BILL_TO_CONTACT_ID | NUMBER | (15) | Bill-to contact identifier | |
| SHIP_TO_CONTACT_ID | NUMBER | (15) | Ship-to contact identifier | |
| CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | The Current serial number on the product. | |
| CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number | |
| SYSTEM_ID | NUMBER | (15) | Not used. | |
| 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 | |
| RECORD_IS_VALID_FLAG | VARCHAR2 | (1) | Flag indicating if the record is valid. | |
| RESOLUTION_CODE | VARCHAR2 | (50) | Resolution Code | |
| ORG_ID | NUMBER | Operating unit identifier | ||
| ORIGINAL_ORDER_NUMBER | NUMBER | Original Order number. | ||
| WORKFLOW_PROCESS_ID | NUMBER | Sequence number used for this action's last workflow process | ||
| CLOSE_DATE | DATE | Date when the Service Request closed. | ||
| PUBLISH_FLAG | VARCHAR2 | (1) | Flag to denote whether the service request is published or not. | |
| INTERFACED_TO_DEPOT_FLAG | VARCHAR2 | (1) | Flag to denote service request is linked to repairs | |
| QA_COLLECTION_ID | NUMBER | Quality Collection identifier. | ||
| CONTRACT_SERVICE_ID | NUMBER | Service line unique identifier | ||
| KB_TYPE | VARCHAR2 | (15) | External knowledge base Type. | |
| KB_SOLUTION_ID | VARCHAR2 | (240) | External knowledge base solution identifier. | |
| TIME_ZONE_ID | NUMBER | (15) | This field stores the time zone id of the time zone specified in the service request form | |
| TIME_DIFFERENCE | NUMBER | The time diferrence between GMT and the timzone of the service request. | ||
| CUSTOMER_PO_NUMBER | VARCHAR2 | (50) | Customer's Purchase Order number. | |
| OWNER_GROUP_ID | NUMBER | The group owner identifier. | ||
| CUSTOMER_TICKET_NUMBER | VARCHAR2 | (50) | Customer's internal helpdesk tracking number. | |
| OBLIGATION_DATE | DATE | Obligation Date | ||
| SITE_ID | NUMBER | Identifier for Support Site. | ||
| CUSTOMER_SITE_ID | NUMBER | Identifier for Customer Site. | ||
| CALLER_TYPE | VARCHAR2 | (30) | Yes | Name of Caller Type |
| PLATFORM_VERSION_ID | NUMBER | Platform Version identifier. | ||
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Version Number of Object from CS_INCIDENTS_ALL_B. | |
| LANGUAGE | VARCHAR2 | (4) | Yes | Language of the service request. |
| SOURCE_LANG | VARCHAR2 | (4) | Yes | Source language of the service request. |
| SUMMARY | VARCHAR2 | (240) | Yes | Summary of the service request. |
| SR_CREATION_CHANNEL | VARCHAR2 | (50) | Service request creation channel. | |
| CP_COMPONENT_ID | NUMBER | Identifier for Installed Base Component. | ||
| CP_COMPONENT_VERSION_ID | NUMBER | Identifier for Installed Base Component Revision. | ||
| CP_SUBCOMPONENT_ID | NUMBER | Identifier for Installed Base Subcomponent. | ||
| CP_SUBCOMPONENT_VERSION_ID | NUMBER | Identifier for Installed Base Subcomponent Revision. | ||
| CP_REVISION_ID | NUMBER | Identifier for Installed Base Product Revision. | ||
| INV_ITEM_REVISION | VARCHAR2 | (240) | Identifier for the Item Revision for a product not in Installed Base. | |
| 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. | |
| INV_ORGANIZATION_ID | NUMBER | This field stores the inventory organization id based on the profile AS_PRODUCT_ORGANIZATION_ID. | ||
| PLATFORM_ID | NUMBER | Identifier for Platform. | ||
| LANGUAGE_ID | NUMBER | Identifier for the Product's Language. | ||
| TERRITORY_ID | NUMBER | Identifier for the Territory of the Service Request. | ||
| CONTRACT_NUMBER | VARCHAR2 | (120) | The contract number. | |
| CONTRACT_ID | NUMBER | Contract identifier. | ||
| PROJECT_NUMBER | VARCHAR2 | (120) | Project number. | |
| CUST_PREF_LANG_ID | NUMBER | Customer prefered language identifier. | ||
| PLATFORM_VERSION | VARCHAR2 | (250) | The Platform Version of the product. | |
| TIER | VARCHAR2 | (250) | The Tier of the Product, against which the SR has been created. | |
| TIER_VERSION | VARCHAR2 | (250) | The Tier Version for the Product, against which the SR has been created. | |
| CATEGORY_ID | NUMBER | The product category Identifier. | ||
| OPERATING_SYSTEM | VARCHAR2 | (250) | The Operating System of the product. | |
| OPERATING_SYSTEM_VERSION | VARCHAR2 | (250) | The version of the Operating System for the product. | |
| DATABASE | VARCHAR2 | (250) | The database on which the product is installed. | |
| DB_VERSION | VARCHAR2 | (250) | The database version on which the product is installed. | |
| GROUP_TYPE | VARCHAR2 | (30) | The Group owner type for the service request. | |
| INV_PLATFORM_ORG_ID | NUMBER | Organization Identifier for the product platform. | ||
| PRODUCT_REVISION | VARCHAR2 | (240) | The Revision Code of the Installed Base Product. | |
| COMPONENT_VERSION | VARCHAR2 | (3) | The Component Version of the Installed Base Product. | |
| SUBCOMPONENT_VERSION | VARCHAR2 | (3) | The SubComponent Version of the Installed Base Product. | |
| COMM_PREF_CODE | VARCHAR2 | (30) | Prefered communication mode for the customer. | |
| LAST_UPDATE_CHANNEL | VARCHAR2 | (30) | This indicates from which channel the service request was last updated. The values can be WEB (iSupport) and PHONE (TeleService). | |
| CUST_PREF_LANG_CODE | VARCHAR2 | (4) | The code for customer's preferred language. | |
| ERROR_CODE | VARCHAR2 | (250) | The error code of the problem reported in the service request. | |
| CATEGORY_SET_ID | NUMBER | Category Set Identifier of Customer Product | ||
| EXTERNAL_REFERENCE | VARCHAR2 | (30) | External Reference Number | |
| INCIDENT_OCCURRED_DATE | DATE | Date on which Incident Occurred. | ||
| INCIDENT_RESOLVED_DATE | DATE | Date on which the Icident was resolved. | ||
| INC_RESPONDED_BY_DATE | DATE | Responded Date of the Incident. | ||
| GROUP_OWNER | VARCHAR2 | (60) | Name of the Group | |
| OWNER | VARCHAR2 | (360) | Name of the Service Request Owner | |
| RESOLUTION_SUMMARY | VARCHAR2 | (250) | Description on the resolution of the problem for the Service Request | |
| INCIDENT_LOCATION_ID | NUMBER | Identifier of the incident location for a Service Request. | ||
| INCIDENT_ADDRESS | VARCHAR2 | (960) | Incident address for a Service Request. | |
| INCIDENT_CITY | VARCHAR2 | (60) | Incident City for a Service Request. | |
| INCIDENT_STATE | VARCHAR2 | (60) | Incident State for a Service Request. | |
| INCIDENT_COUNTRY | VARCHAR2 | (60) | Incident Country for a Service Request. | |
| INCIDENT_PROVINCE | VARCHAR2 | (60) | Incident Province for a Service Request. | |
| INCIDENT_POSTAL_CODE | VARCHAR2 | (60) | Incident Postal Code for a Service Request. | |
| INCIDENT_COUNTY | VARCHAR2 | (60) | Incident County for a Service Request. | |
| 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. | |
| EXTERNAL_ATTRIBUTE_1 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_2 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_3 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_4 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_5 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_6 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_7 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_8 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_9 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_10 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_11 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_12 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_13 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_14 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_ATTRIBUTE_15 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| EXTERNAL_CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column. | |
| CUSTOMER_PHONE_ID | NUMBER | (15) | Identifier of the customer phone. | |
| CUSTOMER_EMAIL_ID | NUMBER | (15) | Identifier of the customer email. | |
| BILL_TO_ACCOUNT_ID | NUMBER | (15) | Identifier of the bill to account. | |
| SHIP_TO_ACCOUNT_ID | NUMBER | (15) | Identifier of the ship to account. | |
| BILL_TO_PARTY_ID | NUMBER | Identifier of the bill to party. | ||
| SHIP_TO_PARTY_ID | NUMBER | Identifier of the ship to party. | ||
| BILL_TO_SITE_ID | NUMBER | Identifier of the bill to site. | ||
| SHIP_TO_SITE_ID | NUMBER | Identifier of the ship to site. | ||
| COVERAGE_TYPE | VARCHAR2 | (30) | Coverage type | |
| PROGRAM_LOGIN_ID | NUMBER | Standard Who Column | ||
| STATUS_FLAG | VARCHAR2 | (3) | Yes | Flag to denote whether the status of the SR is open or closed. |
| PRIMARY_CONTACT_ID | NUMBER | Service Request Contact Point Identifier.Foreign key to sr_contact_point_id of the cs_hz_sr_contact_points table. | ||
| LAST_UPDATE_PROGRAM_CODE | VARCHAR2 | (30) | Last Update Program Code For SR Source | |
| CREATION_PROGRAM_CODE | VARCHAR2 | (30) | Creation Program Code For SR Source. | |
| INCIDENT_POINT_OF_INTEREST | VARCHAR2 | (240) | Point Of Interest of the Incident Address | |
| INCIDENT_CROSS_STREET | VARCHAR2 | (240) | Cross Street of the Incident Address | |
| INCIDENT_DIRECTION_QUALIFIER | VARCHAR2 | (30) | Indicates the Direction of Incident Address, while using a non-Postal Location . Directional Qualifiers are defined as lookup Codes | |
| INCIDENT_DISTANCE_QUALIFIER | VARCHAR2 | (240) | Indicates the distance of the Incident Address from the Incident Point of Interest | |
| INCIDENT_DISTANCE_QUAL_UOM | VARCHAR2 | (30) | Unit of Measure for the Distance from the point of Interest. Distance Unit of Measures are defined as Lookup Codes | |
| INCIDENT_ADDRESS2 | VARCHAR2 | (240) | Second Line of Incident address for a Service Request. | |
| INCIDENT_ADDRESS3 | VARCHAR2 | (240) | Third Line of Incident address for a Service Request. | |
| INCIDENT_ADDRESS4 | VARCHAR2 | (240) | Fourth Line of Incident address for a Service Request. | |
| INCIDENT_ADDRESS_STYLE | VARCHAR2 | (30) | Address Style for Incident Address | |
| INCIDENT_ADDR_LINES_PHONETIC | VARCHAR2 | (560) | Phonetic representation of Incident Address Lines | |
| INCIDENT_PO_BOX_NUMBER | VARCHAR2 | (50) | Post Office Box Number | |
| INCIDENT_HOUSE_NUMBER | VARCHAR2 | (50) | House Number of the Incident Address | |
| INCIDENT_STREET_SUFFIX | VARCHAR2 | (50) | Street Name Suffix such as Road, Avenue or Street | |
| INCIDENT_STREET | VARCHAR2 | (150) | Street Name of Incident Address | |
| INCIDENT_STREET_NUMBER | VARCHAR2 | (50) | Street Number in the Incident Address Line | |
| INCIDENT_FLOOR | VARCHAR2 | (50) | Number or Name assigned to a level within a building or Address | |
| INCIDENT_SUITE | VARCHAR2 | (50) | Numer or Name Given to a Group of Rooms referred as a unit | |
| INCIDENT_POSTAL_PLUS4_CODE | VARCHAR2 | (30) | Extension to the United States postal ZIP Code | |
| INCIDENT_POSITION | VARCHAR2 | (50) | Position of incident address. | |
| INCIDENT_LOCATION_DIRECTIONS | VARCHAR2 | (640) | Directions to the incident location. | |
| INCIDENT_LOCATION_DESCRIPTION | VARCHAR2 | (2000) | Description of the location. | |
| INSTALL_SITE_ID | NUMBER | Party site id of the location where the item is installed. | ||
| INCIDENT_LOCATION_TYPE | VARCHAR2 | (30) | Location type code. | |
| ITEM_SERIAL_NUMBER | VARCHAR2 | (30) | Asset number or rebuildable serial number for maintenance SR's | |
| OWNING_DEPARTMENT_ID | NUMBER | Owning department identifier. | ||
| INCIDENT_LAST_MODIFIED_DATE | DATE | |||
| UNASSIGNED_INDICATOR | VARCHAR2 | (1) | Identifies if SR is unassigned at agent/group or at both the level | |
| ESTIMATE_ID | NUMBER | (15) | Estimate Id | |
| ESTIMATE_BUSINESS_GROUP_ID | NUMBER | (15) | Estimate Business Group Id | |
| GROUP_TERRITORY_ID | NUMBER | Group Territory Id | ||
| OWNER_ASSIGNED_TIME | DATE | Owner Assigned Time | ||
| OWNER_ASSIGNED_FLAG | VARCHAR2 | (1) | Owner Assigned Flag | |
| TEXT_INDEX | VARCHAR2 | (1) | Dummy column for SR text index. | |
| MAINT_ORGANIZATION_ID | NUMBER | eAM Organization ID. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, INCIDENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, INCIDENT_NUMBER
, INCIDENT_DATE
, INCIDENT_STATUS_ID
, INCIDENT_TYPE_ID
, INCIDENT_URGENCY_ID
, INCIDENT_SEVERITY_ID
, INCIDENT_OWNER_ID
, RESOURCE_TYPE
, RESOURCE_SUBTYPE_ID
, INVENTORY_ITEM_ID
, CUSTOMER_ID
, ACCOUNT_ID
, BILL_TO_SITE_USE_ID
, PURCHASE_ORDER_NUM
, EMPLOYEE_ID
, FILED_BY_EMPLOYEE_FLAG
, SHIP_TO_SITE_USE_ID
, PROBLEM_CODE
, EXPECTED_RESOLUTION_DATE
, ACTUAL_RESOLUTION_DATE
, CUSTOMER_PRODUCT_ID
, INSTALL_SITE_USE_ID
, BILL_TO_CONTACT_ID
, SHIP_TO_CONTACT_ID
, CURRENT_SERIAL_NUMBER
, CUSTOMER_NUMBER
, SYSTEM_ID
, 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
, RECORD_IS_VALID_FLAG
, RESOLUTION_CODE
, ORG_ID
, ORIGINAL_ORDER_NUMBER
, WORKFLOW_PROCESS_ID
, CLOSE_DATE
, PUBLISH_FLAG
, INTERFACED_TO_DEPOT_FLAG
, QA_COLLECTION_ID
, CONTRACT_SERVICE_ID
, KB_TYPE
, KB_SOLUTION_ID
, TIME_ZONE_ID
, TIME_DIFFERENCE
, CUSTOMER_PO_NUMBER
, OWNER_GROUP_ID
, CUSTOMER_TICKET_NUMBER
, OBLIGATION_DATE
, SITE_ID
, CUSTOMER_SITE_ID
, CALLER_TYPE
, PLATFORM_VERSION_ID
, OBJECT_VERSION_NUMBER
, LANGUAGE
, SOURCE_LANG
, SUMMARY
, SR_CREATION_CHANNEL
, CP_COMPONENT_ID
, CP_COMPONENT_VERSION_ID
, CP_SUBCOMPONENT_ID
, CP_SUBCOMPONENT_VERSION_ID
, CP_REVISION_ID
, INV_ITEM_REVISION
, INV_COMPONENT_ID
, INV_COMPONENT_VERSION
, INV_SUBCOMPONENT_ID
, INV_SUBCOMPONENT_VERSION
, INV_ORGANIZATION_ID
, PLATFORM_ID
, LANGUAGE_ID
, TERRITORY_ID
, CONTRACT_NUMBER
, CONTRACT_ID
, PROJECT_NUMBER
, CUST_PREF_LANG_ID
, PLATFORM_VERSION
, TIER
, TIER_VERSION
, CATEGORY_ID
, OPERATING_SYSTEM
, OPERATING_SYSTEM_VERSION
, DATABASE
, DB_VERSION
, GROUP_TYPE
, INV_PLATFORM_ORG_ID
, PRODUCT_REVISION
, COMPONENT_VERSION
, SUBCOMPONENT_VERSION
, COMM_PREF_CODE
, LAST_UPDATE_CHANNEL
, CUST_PREF_LANG_CODE
, ERROR_CODE
, CATEGORY_SET_ID
, EXTERNAL_REFERENCE
, INCIDENT_OCCURRED_DATE
, INCIDENT_RESOLVED_DATE
, INC_RESPONDED_BY_DATE
, GROUP_OWNER
, OWNER
, RESOLUTION_SUMMARY
, INCIDENT_LOCATION_ID
, INCIDENT_ADDRESS
, INCIDENT_CITY
, INCIDENT_STATE
, INCIDENT_COUNTRY
, INCIDENT_PROVINCE
, INCIDENT_POSTAL_CODE
, INCIDENT_COUNTY
, 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
, 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
, CUSTOMER_PHONE_ID
, CUSTOMER_EMAIL_ID
, BILL_TO_ACCOUNT_ID
, SHIP_TO_ACCOUNT_ID
, BILL_TO_PARTY_ID
, SHIP_TO_PARTY_ID
, BILL_TO_SITE_ID
, SHIP_TO_SITE_ID
, COVERAGE_TYPE
, PROGRAM_LOGIN_ID
, STATUS_FLAG
, PRIMARY_CONTACT_ID
, LAST_UPDATE_PROGRAM_CODE
, CREATION_PROGRAM_CODE
, INCIDENT_POINT_OF_INTEREST
, INCIDENT_CROSS_STREET
, INCIDENT_DIRECTION_QUALIFIER
, INCIDENT_DISTANCE_QUALIFIER
, INCIDENT_DISTANCE_QUAL_UOM
, INCIDENT_ADDRESS2
, INCIDENT_ADDRESS3
, INCIDENT_ADDRESS4
, INCIDENT_ADDRESS_STYLE
, INCIDENT_ADDR_LINES_PHONETIC
, INCIDENT_PO_BOX_NUMBER
, INCIDENT_HOUSE_NUMBER
, INCIDENT_STREET_SUFFIX
, INCIDENT_STREET
, INCIDENT_STREET_NUMBER
, INCIDENT_FLOOR
, INCIDENT_SUITE
, INCIDENT_POSTAL_PLUS4_CODE
, INCIDENT_POSITION
, INCIDENT_LOCATION_DIRECTIONS
, INCIDENT_LOCATION_DESCRIPTION
, INSTALL_SITE_ID
, INCIDENT_LOCATION_TYPE
, ITEM_SERIAL_NUMBER
, OWNING_DEPARTMENT_ID
, INCIDENT_LAST_MODIFIED_DATE
, UNASSIGNED_INDICATOR
, ESTIMATE_ID
, ESTIMATE_BUSINESS_GROUP_ID
, GROUP_TERRITORY_ID
, OWNER_ASSIGNED_TIME
, OWNER_ASSIGNED_FLAG
, TEXT_INDEX
, MAINT_ORGANIZATION_ID
FROM APPS.CS_INCIDENTS_ALL_VL;
APPS
CS_INCIDENTS_ALL_B
CS_INCIDENTS_ALL_TL
APPS
AHL_COMPLETIONS_PVT
- show dependent code
AHL_MEL_CDL_APPROVALS_PVT
- show dependent code
AHL_MR_INSTANCES_V
AHL_PRD_DISP_UTIL_PVT
- show dependent code
AHL_UE_DEFERRAL_DETAILS_V
AHL_UMP_PROCESSUNIT_EXTN_PVT
- show dependent code
AHL_UMP_UTIL_PKG
- show dependent code
CSD_BULK_RECEIVE_UTIL
- show dependent code
CSD_ESTIMATE_UTILS_PVT
- show dependent code
CSD_INCIDENTS_NON_SEC_V
CSD_REPAIRS_UTIL
- show dependent code
CSFW_SERVICEREQUEST_PUB
- show dependent code
CSF_PO_CONTACT_POINTS_V
CS_INCIDENTS
CS_INCIDENTS_ALL
CS_INCIDENTS_WORKFLOW_V
CS_SERVICEREQUEST_PVT
- show dependent code
CS_SERVICEREQUEST_PVT
- show dependent code
CS_SR_CHILD_AUDIT_PKG
- show dependent code
CS_SR_DUPLICATE_CHECK_V
CS_SR_INCIDENTS_V
CS_SR_REPORT_V
CS_SR_WF_DUP_CHK_PVT
- show dependent code
CS_SYSTEM_SR_LINKS_V
CS_WF_ACTIVITIES_PKG
- show dependent code
CS_WF_AUTO_NTFY_UPDATE_PKG
- show dependent code
CUG_GENERIC_WF_PKG
- show dependent code
|
|
|
|