VIEW: APPS.CS_SR_INCIDENTS_V

Source

View Text - Preformatted

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, INC.INSTRUMENT_PAYMENT_USE_ID, INC.project_task_id, inc.project_id, INC.SLA_DATE_1, INC.SLA_DATE_2, INC.SLA_DATE_3, INC.SLA_DATE_4, INC.SLA_DATE_5, INC.SLA_DATE_6, INC.SLA_DURATION_1, INC.SLA_DURATION_2, INC.PRICE_LIST_HEADER_ID, INC.EXPENDITURE_ORG_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'

View Text - HTML Formatted

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
, INC.INSTRUMENT_PAYMENT_USE_ID
, INC.PROJECT_TASK_ID
, INC.PROJECT_ID
, INC.SLA_DATE_1
, INC.SLA_DATE_2
, INC.SLA_DATE_3
, INC.SLA_DATE_4
, INC.SLA_DATE_5
, INC.SLA_DATE_6
, INC.SLA_DURATION_1
, INC.SLA_DURATION_2
, INC.PRICE_LIST_HEADER_ID
, INC.EXPENDITURE_ORG_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'