View: CS_SR_INCIDENTS_V

Product:	CS - Service
Description:	Base view for SR main form.
Implementation/DBA Data:	APPS.CS_SR_INCIDENTS_V

View Text

SELECT INC.ROWID ROW_ID
, INC.INCIDENT_ID
, INC.ORG_ID
, INC.LAST_UPDATE_DATE
, INC.LAST_UPDATED_BY
, INC.CREATION_DATE
, INC.CREATED_BY
, INC.LAST_UPDATE_LOGIN
, INC.INCIDENT_NUMBER
, INC.INCIDENT_STATUS_ID
, INC.INCIDENT_TYPE_ID
, INC.INCIDENT_URGENCY_ID
, INC.INCIDENT_SEVERITY_ID
, INC.SUMMARY
, INC.INCIDENT_OWNER_ID
, INC.RESOURCE_TYPE
, INC.RESOURCE_SUBTYPE_ID
, INC.INVENTORY_ITEM_ID
, INC.SHIP_TO_SITE_USE_ID
, INC.SHIP_TO_CONTACT_ID
, INC.BILL_TO_SITE_USE_ID
, INC.BILL_TO_CONTACT_ID
, INC.INSTALL_SITE_USE_ID
, INC.PROBLEM_CODE
, INC.EXPECTED_RESOLUTION_DATE
, INC.ACTUAL_RESOLUTION_DATE
, INC.INCIDENT_DATE
, INC.CUSTOMER_PRODUCT_ID
, INC.INCIDENT_ATTRIBUTE_1
, INC.INCIDENT_ATTRIBUTE_2
, INC.INCIDENT_ATTRIBUTE_3
, INC.INCIDENT_ATTRIBUTE_4
, INC.INCIDENT_ATTRIBUTE_5
, INC.INCIDENT_ATTRIBUTE_6
, INC.INCIDENT_ATTRIBUTE_7
, INC.INCIDENT_ATTRIBUTE_8
, INC.INCIDENT_ATTRIBUTE_9
, INC.INCIDENT_ATTRIBUTE_10
, INC.INCIDENT_ATTRIBUTE_11
, INC.INCIDENT_ATTRIBUTE_12
, INC.INCIDENT_ATTRIBUTE_13
, INC.INCIDENT_ATTRIBUTE_14
, INC.INCIDENT_ATTRIBUTE_15
, INC.INCIDENT_CONTEXT
, INC.RECORD_IS_VALID_FLAG
, INC.RESOLUTION_CODE
, INC.INTERFACED_TO_DEPOT_FLAG
, TYPE.NAME INCIDENT_TYPE
, SEV.NAME SEVERITY
, STATUS.NAME STATUS_CODE
, URGENCY.NAME URGENCY
, NVL(STATUS.CLOSE_FLAG
, 'N') CLOSED_FLAG
, INC.FILED_BY_EMPLOYEE_FLAG
, INC.CUSTOMER_ID
, INC.ACCOUNT_ID
, INC.EMPLOYEE_ID
, INC.CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER_NV
, INC.PURCHASE_ORDER_NUM
, INC.ORIGINAL_ORDER_NUMBER
, INC.WORKFLOW_PROCESS_ID
, INC.CLOSE_DATE DATE_CLOSED
, INC.PUBLISH_FLAG
, INC.QA_COLLECTION_ID
, INC.CONTRACT_SERVICE_ID
, INC.KB_SOLUTION_ID
, INC.TIME_ZONE_ID
, INC.CUSTOMER_PO_NUMBER
, INC.CUSTOMER_TICKET_NUMBER
, INC.OBLIGATION_DATE
, INC.SITE_ID
, INC.CUSTOMER_SITE_ID
, INC.SR_CREATION_CHANNEL
, INC.PLATFORM_VERSION_ID
, INC.CALLER_TYPE
, INC.CP_COMPONENT_ID
, INC.CP_COMPONENT_VERSION_ID
, INC.CP_SUBCOMPONENT_ID
, INC.CP_SUBCOMPONENT_VERSION_ID
, INC.CP_REVISION_ID
, INC.INV_ITEM_REVISION
, INC.INV_COMPONENT_ID
, INC.INV_COMPONENT_VERSION
, INC.INV_SUBCOMPONENT_ID
, INC.INV_SUBCOMPONENT_VERSION
, INC.INV_ORGANIZATION_ID
, INC.PLATFORM_ID
, INC.LANGUAGE_ID
, INC.TERRITORY_ID
, INC.TIME_DIFFERENCE
, SR_CONT.PARTY_ID CONTACT_PARTY_ID
, SR_CONT.CONTACT_POINT_ID
, INC.OBJECT_VERSION_NUMBER
, SR_CONT.CONTACT_TYPE
, SEV.DISPLAY_COLOR COLOR_SEVERITY
, STATUS.DISPLAY_COLOR COLOR_STATUS
, URGENCY.DISPLAY_COLOR COLOR_URGENCY
, INC.CONTRACT_NUMBER
, INC.CONTRACT_ID
, INC.PROJECT_NUMBER
, INC.CUST_PREF_LANG_ID
, INC.PLATFORM_VERSION
, INC.TIER
, INC.TIER_VERSION
, INC.CATEGORY_ID
, INC.OPERATING_SYSTEM
, INC.OPERATING_SYSTEM_VERSION
, INC.DATABASE
, INC.DB_VERSION
, INC.GROUP_TYPE
, INC.OWNER_GROUP_ID
, INC.INV_PLATFORM_ORG_ID
, INC.PRODUCT_REVISION
, INC.COMPONENT_VERSION
, INC.SUBCOMPONENT_VERSION
, INC.COMM_PREF_CODE
, INC.LAST_UPDATE_CHANNEL
, INC.CUST_PREF_LANG_CODE
, INC.ERROR_CODE
, INC.CATEGORY_SET_ID
, INC.EXTERNAL_REFERENCE
, INC.SYSTEM_ID
, INC.INCIDENT_OCCURRED_DATE
, INC.INCIDENT_RESOLVED_DATE
, INC.INC_RESPONDED_BY_DATE
, INC.GROUP_OWNER
, INC.OWNER
, INC.RESOLUTION_SUMMARY
, INC.INCIDENT_LOCATION_ID
, INC.INCIDENT_ADDRESS
, INC.INCIDENT_CITY
, INC.INCIDENT_STATE
, INC.INCIDENT_COUNTRY
, INC.INCIDENT_PROVINCE
, INC.INCIDENT_POSTAL_CODE
, INC.INCIDENT_COUNTY
, INC.CREDIT_CARD_NUMBER
, INC.CREDIT_CARD_TYPE_CODE
, INC.CREDIT_CARD_EXPIRATION_DATE
, INC.CREDIT_CARD_HOLDER_FNAME
, INC.CREDIT_CARD_HOLDER_MNAME
, INC.CREDIT_CARD_HOLDER_LNAME
, INC.CREDIT_CARD_ID
, INC.CUSTOMER_EMAIL_ID
, INC.CUSTOMER_PHONE_ID
, INC.EXTERNAL_ATTRIBUTE_1
, INC.EXTERNAL_ATTRIBUTE_2
, INC.EXTERNAL_ATTRIBUTE_3
, INC.EXTERNAL_ATTRIBUTE_4
, INC.EXTERNAL_ATTRIBUTE_5
, INC.EXTERNAL_ATTRIBUTE_6
, INC.EXTERNAL_ATTRIBUTE_7
, INC.EXTERNAL_ATTRIBUTE_8
, INC.EXTERNAL_ATTRIBUTE_9
, INC.EXTERNAL_ATTRIBUTE_10
, INC.EXTERNAL_ATTRIBUTE_11
, INC.EXTERNAL_ATTRIBUTE_12
, INC.EXTERNAL_ATTRIBUTE_13
, INC.EXTERNAL_ATTRIBUTE_14
, INC.EXTERNAL_ATTRIBUTE_15
, INC.EXTERNAL_CONTEXT
, INC.BILL_TO_ACCOUNT_ID
, INC.SHIP_TO_ACCOUNT_ID
, INC.BILL_TO_PARTY_ID
, INC.SHIP_TO_PARTY_ID
, INC.COVERAGE_TYPE
, INC.INCIDENT_POINT_OF_INTEREST
, INC.INCIDENT_CROSS_STREET
, INC.INCIDENT_DIRECTION_QUALIFIER
, INC.INCIDENT_DISTANCE_QUALIFIER
, INC.INCIDENT_DISTANCE_QUAL_UOM
, INC.INCIDENT_ADDRESS2
, INC.INCIDENT_ADDRESS3
, INC.INCIDENT_ADDRESS4
, INC.INCIDENT_ADDRESS_STYLE
, INC.INCIDENT_ADDR_LINES_PHONETIC
, INC.INCIDENT_PO_BOX_NUMBER
, INC.INCIDENT_HOUSE_NUMBER
, INC.INCIDENT_STREET_SUFFIX
, INC.INCIDENT_STREET
, INC.INCIDENT_STREET_NUMBER
, INC.INCIDENT_FLOOR
, INC.INCIDENT_SUITE
, INC.INCIDENT_POSTAL_PLUS4_CODE
, INC.INCIDENT_POSITION
, INC.INCIDENT_LOCATION_DIRECTIONS
, INC.INCIDENT_LOCATION_DESCRIPTION
, INC.SHIP_TO_SITE_ID
, INC.BILL_TO_SITE_ID
, INC.INSTALL_SITE_ID
, INCIDENT_LOCATION_TYPE
, INC.ITEM_SERIAL_NUMBER
, INC.OWNING_DEPARTMENT_ID
, TYPE.MAINTENANCE_FLAG INCIDENT_TYPE_MAINT_FLAG
, TYPE.CMRO_FLAG
, INC.INCIDENT_LAST_MODIFIED_DATE
, INC.MAINT_ORGANIZATION_ID
FROM CS_INCIDENT_TYPES_VL TYPE
, CS_INCIDENT_SEVERITIES_VL SEV
, CS_INCIDENT_STATUSES_VL STATUS
, CS_INCIDENT_URGENCIES_VL URGENCY
, CS_INCIDENTS_ALL_VL INC
, CS_HZ_SR_CONTACT_POINTS SR_CONT
WHERE INC.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID
AND TYPE.LANGUAGE = USERENV('LANG')
AND INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
AND INC.INCIDENT_URGENCY_ID = URGENCY.INCIDENT_URGENCY_ID(+)
AND INC.INCIDENT_SEVERITY_ID = SEV.INCIDENT_SEVERITY_ID
AND SR_CONT.INCIDENT_ID (+) = INC.INCIDENT_ID
AND SR_CONT.PRIMARY_FLAG (+) = 'Y'

Columns