Product: | CS - Service |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT FIELD_SERVICE_INTERFACE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, STATUS_FLAG
, ORG_ID
, INCIDENT_NUMBER
, ACTION_NUM
, INCIDENT_DATE
, BUSINESS_PROCESS_ID
, PROBLEM_CODE
, PROBLEM_DESCRIPTION
, RESOLUTION_CODE
, RESOLUTION_DESCRIPTION
, INCIDENT_URGENCY_ID
, URGENCY
, INCIDENT_STATUS_ID
, STATUS_CODE
, STATUS_DATE
, INCIDENT_TYPE_ID
, INCIDENT_TYPE
, DISPATCHER_ID
, DISPATCHER_NAME
, COVERED_BY_CONTRACT
, CURRENT_CONTACT_NAME
, CURRENT_CONTACT_TELEPHONE
, CURRENT_CONTACT_AREA_CODE
, CURRENT_CONTACT_EXTENSION
, CURRENT_CONTACT_FAX_NUMBER
, CURRENT_CONTACT_FAX_AREA_CODE
, CURRENT_CONTACT_EMAIL_ADDRESS
, SHIP_TO_ADDRESS_LINE1
, SHIP_TO_ADDRESS_LINE2
, POSTAL_CODE
, CITY
, STATE
, COUNTRY
, START_TIME
, END_TIME
, EARLIEST_START_TIME
, LATEST_FINISH_TIME
, APPOINTMENT
, REQUEST_DURATION
, EMPLOYEE_ID
, EMPLOYEE_NAME
, CUSTOMER_ID
, CUSTOMER_NUMBER
, CUSTOMER_NAME
, INVENTORY_ITEM_ID
, PRODUCT
, PRODUCT_DESCRIPTION
, ORGANIZATION_ID
, REFERENCE_NUMBER
, CURRENT_SERIAL_NUMBER
, INSTALLATION_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, SR_PROBLEM_DESCRIPTION
, SR_RESOLUTION_DESCRIPTION
, ACTION_STATUS_UPDATED
, INCIDENT_SEVERITY_ID
, INCIDENT_SEVERITY_NAME
, INC_PROB_DESCRIPTION
, ACTION_STATUS_ID
, PROBLEM_SUMMARY
FROM CS_MFS_INTERFACE_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)