[Home] [Help] [Dependency Information]
Object Name: | CS_SR_SEARCH_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CS.CS_SR_SEARCH_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row id | |
INCIDENT_ID | NUMBER | (15) | Yes | Incident id |
ORG_ID | NUMBER | Organization id | ||
LAST_UPDATE_DATE | DATE | Yes | Date of last update of the record | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Person who updated the record last |
CREATION_DATE | DATE | Yes | Date the record created | |
CREATED_BY | NUMBER | (15) | Yes | Person who created the record |
LAST_UPDATE_LOGIN | NUMBER | (15) | Login name of the last update | |
INCIDENT_NUMBER | VARCHAR2 | (64) | Yes | Incident no. |
INCIDENT_NUMBER_N | VARCHAR2 | (64) | Yes | Incident no. in number format |
INCIDENT_STATUS_ID | NUMBER | (15) | Yes | Incident status id |
INCIDENT_TYPE_ID | NUMBER | (15) | Yes | Incident type id |
INCIDENT_URGENCY_ID | NUMBER | (15) | Incident urgency id | |
INCIDENT_SEVERITY_ID | NUMBER | (15) | Yes | Incident severity id |
SUMMARY | VARCHAR2 | (240) | Yes | Summary of the problem |
INCIDENT_OWNER_ID | NUMBER | (15) | Owner id of the SR | |
RESOURCE_TYPE | VARCHAR2 | (30) | Resource type | |
RESOURCE_SUBTYPE_ID | NUMBER | Resource subtype id | ||
INVENTORY_ITEM_ID | NUMBER | (15) | Inventory item id | |
SHIP_TO_SITE_USE_ID | NUMBER | (15) | Site id of the place to which goods will be shipped | |
SHIP_TO_CONTACT_ID | NUMBER | (15) | Contact id of the person to whom shipment will be done | |
BILL_TO_SITE_USE_ID | NUMBER | (15) | Site id to which bills will be despatched | |
BILL_TO_CONTACT_ID | NUMBER | (15) | Contact id of the person to whom bills will be despatched | |
INSTALL_SITE_USE_ID | NUMBER | (15) | Site id at which installation was done | |
PROBLEM_CODE | VARCHAR2 | (80) | Problem code | |
EXPECTED_RESOLUTION_DATE | DATE | Date the resolution is expected | ||
ACTUAL_RESOLUTION_DATE | DATE | Date actually the problem was resolved | ||
INCIDENT_DATE | DATE | Incident date | ||
CUSTOMER_PRODUCT_ID | NUMBER | (15) | Customer product id | |
INCIDENT_ATTRIBUTE_1 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_2 | VARCHAR2 | (150) | flex field | |
INCIDENT_ATTRIBUTE_3 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_4 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_5 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_6 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_7 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_8 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_9 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_10 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_11 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_12 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_13 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_14 | VARCHAR2 | (150) | Flex field | |
INCIDENT_ATTRIBUTE_15 | VARCHAR2 | (150) | Flex field | |
INCIDENT_CONTEXT | VARCHAR2 | (30) | Incident context | |
RECORD_IS_VALID_FLAG | VARCHAR2 | (1) | Whether record is valid or not | |
RESOLUTION_CODE | VARCHAR2 | (50) | Resolution code | |
INTERFACED_TO_DEPOT_FLAG | VARCHAR2 | (1) | Interfaced to depot flag | |
INCIDENT_TYPE | VARCHAR2 | (90) | Incident type name | |
SEVERITY | VARCHAR2 | (90) | Severity name | |
STATUS_CODE | VARCHAR2 | (90) | Status name | |
URGENCY | VARCHAR2 | (90) | Urgency name | |
FILED_BY_EMPLOYEE_FLAG | VARCHAR2 | (1) | Whether SR was filed by employee or not | |
CUSTOMER_ID | NUMBER | (15) | Customer id | |
ACCOUNT_ID | NUMBER | Account id | ||
EMPLOYEE_ID | NUMBER | (15) | Employee id | |
EMPLOYEE_NAME | VARCHAR2 | (0) | Employee name | |
EMPLOYEE_NUMBER | VARCHAR2 | (0) | Employee number | |
CURRENT_SERIAL_NUMBER_NV | VARCHAR2 | (30) | Current serial number | |
PURCHASE_ORDER_NUM | VARCHAR2 | (50) | Purchase order number | |
ORIGINAL_ORDER_NUMBER | NUMBER | Original order number | ||
WORKFLOW_PROCESS_ID | NUMBER | Workflow process id | ||
DATE_CLOSED | DATE | Date the SR was closed | ||
PUBLISH_FLAG | VARCHAR2 | (1) | Publish flag | |
QA_COLLECTION_ID | NUMBER | QA collection id | ||
CONTRACT_SERVICE_ID | NUMBER | Contract service id | ||
KB_SOLUTION_ID | VARCHAR2 | (240) | Knowledge base solution id | |
TIME_ZONE_ID | NUMBER | (15) | Time zone id | |
CUSTOMER_PO_NUMBER | VARCHAR2 | (50) | Customer purchase order number | |
CUSTOMER_TICKET_NUMBER | VARCHAR2 | (50) | Customer ticket number | |
OBLIGATION_DATE | DATE | Obligation date | ||
SITE_ID | NUMBER | Site id | ||
CUSTOMER_SITE_ID | NUMBER | Customer site id | ||
SR_CREATION_CHANNEL | VARCHAR2 | (50) | Service request creation channel (Web, phone etc.) | |
PLATFORM_VERSION_ID | NUMBER | Platform version id | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer number | |
CALLER_TYPE | VARCHAR2 | (30) | Yes | Caller type |
CP_COMPONENT_ID | NUMBER | Customer product component id | ||
CP_COMPONENT_VERSION_ID | NUMBER | Customer product component version id | ||
CP_SUBCOMPONENT_ID | NUMBER | Customer product subcomponent id | ||
CP_SUBCOMPONENT_VERSION_ID | NUMBER | Customer product subcomponent version id | ||
CP_REVISION_ID | NUMBER | Customer product revision id | ||
INV_ITEM_REVISION | VARCHAR2 | (240) | Inventory item revision | |
INV_COMPONENT_ID | NUMBER | Inventory component id | ||
INV_COMPONENT_VERSION | VARCHAR2 | (90) | Inventory component version | |
INV_SUBCOMPONENT_ID | NUMBER | Inventory subcomponent id | ||
INV_SUBCOMPONENT_VERSION | VARCHAR2 | (90) | Inventory subcomponent version | |
PLATFORM_ID | NUMBER | Platform id | ||
LANGUAGE_ID | NUMBER | Language id | ||
TERRITORY_ID | NUMBER | Territory id | ||
TIME_DIFFERENCE | NUMBER | Time difference | ||
INV_ORGANIZATION_ID | NUMBER | Inventory organization id | ||
PRODUCT_NAME | VARCHAR2 | (40) | Product name | |
PRODUCT_DESCRIPTION | VARCHAR2 | (240) | Product description | |
OWNER | VARCHAR2 | (360) | SR owner name | |
COMPANY_NAME | VARCHAR2 | (360) | Company name | |
PERSON_FIRST_NAME | VARCHAR2 | (150) | Contact person first name | |
PERSON_LAST_NAME | VARCHAR2 | (150) | Contact person last name | |
CONTACT_NAME | VARCHAR2 | (301) | Contact person name | |
COUNTRY_CODE | VARCHAR2 | (10) | Telephone Country code | |
AREA_CODE | VARCHAR2 | (10) | Telephone area code | |
PHONE_NUMBER | VARCHAR2 | (40) | Telephone number | |
PHONE | VARCHAR2 | (62) | Whole phone no. including country code, area code | |
EXT | VARCHAR2 | (20) | Telephone extension | |
VARCHAR2 | (2000) | Contact person email id | ||
PHONE_TYPE | VARCHAR2 | (30) | Telephone type (Work, Home etc.) | |
CONTACT_PARTY_ID | NUMBER | Contact party id | ||
CONTACT_POINT_ID | NUMBER | Contact point id | ||
ACCOUNT | VARCHAR2 | (30) | Account no. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object version number | |
PERSON_TITLE | VARCHAR2 | (30) | Person title | |
CALLER_TYPE_NAME | VARCHAR2 | (80) | Caller type name | |
CALLER_TYPE_DESCRIPTION | VARCHAR2 | (240) | Caller type description | |
TIME_ZONE_NAME | VARCHAR2 | (50) | Time zone name | |
ORGANIZATION_ID | NUMBER | Organization id | ||
COUNTRY | VARCHAR2 | (60) | Country of the customer. | |
CONTRACT_NUMBER | VARCHAR2 | (120) | ||
CONTRACT_ID | NUMBER | |||
PROJECT_NUMBER | VARCHAR2 | (120) | ||
CONTACT_TYPE | VARCHAR2 | (30) | The contact type of the party. | |
CONTACT_NUMBER | VARCHAR2 | (30) | The contact number of the party. | |
GROUP_TYPE | VARCHAR2 | (30) | The group owner type for the SR. | |
OWNER_GROUP_ID | NUMBER | The group owner identifier for the SR. | ||
ERROR_CODE | VARCHAR2 | (250) | The error code of the problem reported in the service request. | |
SYSTEM_ID | NUMBER | (15) | System Identification Number. | |
EXTERNAL_REFERENCE | VARCHAR2 | (30) | External Reference number Store the Tag Number from the UI | |
INCIDENT_OCCURRED_DATE | DATE | Date on which Incident Occurred. | ||
GROUP_OWNER | VARCHAR2 | (60) | Name of the Group | |
CATEGORY_ID | NUMBER | Category Identification Number. | ||
INCIDENT_ADDRESS | VARCHAR2 | (960) | The Incident Address | |
INCIDENT_LOCATION_ID | NUMBER | The incident Location identifier. | ||
INCIDENT_COUNTRY | VARCHAR2 | (60) | The incident country. | |
INCIDENT_POSTAL_CODE | VARCHAR2 | (60) | The Incident Postal code. | |
INCIDENT_STATE | VARCHAR2 | (60) | The state of the incident address. | |
INCIDENT_LOCATION_TYPE | VARCHAR2 | (30) | The Incident Location Type. | |
PRIMARY_FLAG | VARCHAR2 | (1) | The primary flag of the contact. | |
STATUS_FLAG | VARCHAR2 | (3) | Yes | The status flag indicates if the Service Request is open or closed. |
ITEM_SERIAL_NUMBER | VARCHAR2 | (30) | This column will store the serial number field for EAM SRs | |
INCIDENT_ADDRESS2 | VARCHAR2 | (240) | The Incident Address line 2. | |
INCIDENT_ADDRESS3 | VARCHAR2 | (240) | The Incident Address line 3. | |
INCIDENT_ADDRESS4 | VARCHAR2 | (240) | The Incident Address line 4. | |
CUSTOMER_ALIAS | VARCHAR2 | (240) | Customer Alias. | |
PARTY_ROLE_CODE | VARCHAR2 | (30) | Party Role Code | |
TEXT_INDEX | VARCHAR2 | (1) | Text Index |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, INCIDENT_ID
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, INCIDENT_NUMBER
, INCIDENT_NUMBER_N
, INCIDENT_STATUS_ID
, INCIDENT_TYPE_ID
, INCIDENT_URGENCY_ID
, INCIDENT_SEVERITY_ID
, SUMMARY
, INCIDENT_OWNER_ID
, RESOURCE_TYPE
, RESOURCE_SUBTYPE_ID
, INVENTORY_ITEM_ID
, SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID
, BILL_TO_SITE_USE_ID
, BILL_TO_CONTACT_ID
, INSTALL_SITE_USE_ID
, PROBLEM_CODE
, EXPECTED_RESOLUTION_DATE
, ACTUAL_RESOLUTION_DATE
, INCIDENT_DATE
, CUSTOMER_PRODUCT_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
, INTERFACED_TO_DEPOT_FLAG
, INCIDENT_TYPE
, SEVERITY
, STATUS_CODE
, URGENCY
, FILED_BY_EMPLOYEE_FLAG
, CUSTOMER_ID
, ACCOUNT_ID
, EMPLOYEE_ID
, EMPLOYEE_NAME
, EMPLOYEE_NUMBER
, CURRENT_SERIAL_NUMBER_NV
, PURCHASE_ORDER_NUM
, ORIGINAL_ORDER_NUMBER
, WORKFLOW_PROCESS_ID
, DATE_CLOSED
, PUBLISH_FLAG
, QA_COLLECTION_ID
, CONTRACT_SERVICE_ID
, KB_SOLUTION_ID
, TIME_ZONE_ID
, CUSTOMER_PO_NUMBER
, CUSTOMER_TICKET_NUMBER
, OBLIGATION_DATE
, SITE_ID
, CUSTOMER_SITE_ID
, SR_CREATION_CHANNEL
, PLATFORM_VERSION_ID
, CUSTOMER_NUMBER
, CALLER_TYPE
, 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
, PLATFORM_ID
, LANGUAGE_ID
, TERRITORY_ID
, TIME_DIFFERENCE
, INV_ORGANIZATION_ID
, PRODUCT_NAME
, PRODUCT_DESCRIPTION
, OWNER
, COMPANY_NAME
, PERSON_FIRST_NAME
, PERSON_LAST_NAME
, CONTACT_NAME
, COUNTRY_CODE
, AREA_CODE
, PHONE_NUMBER
, PHONE
, EXT
, EMAIL
, PHONE_TYPE
, CONTACT_PARTY_ID
, CONTACT_POINT_ID
, ACCOUNT
, OBJECT_VERSION_NUMBER
, PERSON_TITLE
, CALLER_TYPE_NAME
, CALLER_TYPE_DESCRIPTION
, TIME_ZONE_NAME
, ORGANIZATION_ID
, COUNTRY
, CONTRACT_NUMBER
, CONTRACT_ID
, PROJECT_NUMBER
, CONTACT_TYPE
, CONTACT_NUMBER
, GROUP_TYPE
, OWNER_GROUP_ID
, ERROR_CODE
, SYSTEM_ID
, EXTERNAL_REFERENCE
, INCIDENT_OCCURRED_DATE
, GROUP_OWNER
, CATEGORY_ID
, INCIDENT_ADDRESS
, INCIDENT_LOCATION_ID
, INCIDENT_COUNTRY
, INCIDENT_POSTAL_CODE
, INCIDENT_STATE
, INCIDENT_LOCATION_TYPE
, PRIMARY_FLAG
, STATUS_FLAG
, ITEM_SERIAL_NUMBER
, INCIDENT_ADDRESS2
, INCIDENT_ADDRESS3
, INCIDENT_ADDRESS4
, CUSTOMER_ALIAS
, PARTY_ROLE_CODE
, TEXT_INDEX
FROM APPS.CS_SR_SEARCH_V;
APPS.CS_SR_SEARCH_V is not referenced by any database object
|
|
|