(
SELECT
B.ROWID ROW_ID ,
B.INCIDENT_ID ,
B.LAST_UPDATE_DATE ,
B.LAST_UPDATED_BY ,
B.CREATION_DATE ,
B.CREATED_BY ,
B.LAST_UPDATE_LOGIN ,
B.INCIDENT_NUMBER ,
B.INCIDENT_DATE ,
B.INCIDENT_STATUS_ID ,
B.INCIDENT_TYPE_ID ,
B.INCIDENT_URGENCY_ID ,
B.INCIDENT_SEVERITY_ID ,
B.INCIDENT_OWNER_ID ,
B.RESOURCE_TYPE ,
B.RESOURCE_SUBTYPE_ID ,
B.INVENTORY_ITEM_ID ,
B.CUSTOMER_ID ,
B.ACCOUNT_ID ,
B.BILL_TO_SITE_USE_ID ,
B.PURCHASE_ORDER_NUM ,
B.EMPLOYEE_ID ,
B.FILED_BY_EMPLOYEE_FLAG ,
B.SHIP_TO_SITE_USE_ID ,
B.PROBLEM_CODE ,
B.EXPECTED_RESOLUTION_DATE ,
B.ACTUAL_RESOLUTION_DATE ,
B.CUSTOMER_PRODUCT_ID ,
B.INSTALL_SITE_USE_ID ,
B.BILL_TO_CONTACT_ID ,
B.SHIP_TO_CONTACT_ID ,
B.CURRENT_SERIAL_NUMBER ,
B.CUSTOMER_NUMBER ,
B.SYSTEM_ID ,
B.INCIDENT_ATTRIBUTE_1 ,
B.INCIDENT_ATTRIBUTE_2 ,
B.INCIDENT_ATTRIBUTE_3 ,
B.INCIDENT_ATTRIBUTE_4 ,
B.INCIDENT_ATTRIBUTE_5 ,
B.INCIDENT_ATTRIBUTE_6 ,
B.INCIDENT_ATTRIBUTE_7 ,
B.INCIDENT_ATTRIBUTE_8 ,
B.INCIDENT_ATTRIBUTE_9 ,
B.INCIDENT_ATTRIBUTE_10 ,
B.INCIDENT_ATTRIBUTE_11 ,
B.INCIDENT_ATTRIBUTE_12 ,
B.INCIDENT_ATTRIBUTE_13 ,
B.INCIDENT_ATTRIBUTE_14 ,
B.INCIDENT_ATTRIBUTE_15 ,
B.INCIDENT_CONTEXT ,
B.RECORD_IS_VALID_FLAG ,
B.RESOLUTION_CODE ,
B.ORG_ID ,
B.ORIGINAL_ORDER_NUMBER ,
B.WORKFLOW_PROCESS_ID ,
B.CLOSE_DATE ,
B.PUBLISH_FLAG ,
B.INTERFACED_TO_DEPOT_FLAG ,
B.QA_COLLECTION_ID ,
B.CONTRACT_SERVICE_ID ,
B.KB_TYPE ,
B.KB_SOLUTION_ID ,
B.TIME_ZONE_ID ,
B.TIME_DIFFERENCE ,
B.CUSTOMER_PO_NUMBER ,
B.OWNER_GROUP_ID ,
B.CUSTOMER_TICKET_NUMBER ,
B.OBLIGATION_DATE ,
B.SITE_ID ,
B.CUSTOMER_SITE_ID ,
B.CALLER_TYPE ,
B.PLATFORM_VERSION_ID ,
B.OBJECT_VERSION_NUMBER ,
TL.LANGUAGE ,
TL.SOURCE_LANG ,
TL.SUMMARY ,
B.SR_CREATION_CHANNEL ,
B.CP_COMPONENT_ID ,
B.CP_COMPONENT_VERSION_ID ,
B.CP_SUBCOMPONENT_ID ,
B.CP_SUBCOMPONENT_VERSION_ID ,
B.CP_REVISION_ID ,
B.INV_ITEM_REVISION ,
B.INV_COMPONENT_ID ,
B.INV_COMPONENT_VERSION ,
B.INV_SUBCOMPONENT_ID ,
B.INV_SUBCOMPONENT_VERSION ,
B.INV_ORGANIZATION_ID ,
B.PLATFORM_ID ,
B.LANGUAGE_ID ,
B.TERRITORY_ID ,
B.CONTRACT_NUMBER ,
B.CONTRACT_ID ,
B.PROJECT_NUMBER ,
B.CUST_PREF_LANG_ID ,
B.PLATFORM_VERSION ,
B.TIER ,
B.TIER_VERSION ,
B.CATEGORY_ID ,
B.OPERATING_SYSTEM ,
B.OPERATING_SYSTEM_VERSION ,
B.DATABASE ,
B.DB_VERSION ,
B.GROUP_TYPE ,
B.INV_PLATFORM_ORG_ID ,
B.PRODUCT_REVISION ,
B.COMPONENT_VERSION ,
B.SUBCOMPONENT_VERSION ,
B.COMM_PREF_CODE ,
B.LAST_UPDATE_CHANNEL ,
B.CUST_PREF_LANG_CODE ,
B.ERROR_CODE ,
B.CATEGORY_SET_ID ,
B.EXTERNAL_REFERENCE ,
B.INCIDENT_OCCURRED_DATE ,
B.INCIDENT_RESOLVED_DATE ,
B.INC_RESPONDED_BY_DATE ,
TL.GROUP_OWNER ,
TL.OWNER ,
TL.RESOLUTION_SUMMARY ,
B.INCIDENT_LOCATION_ID ,
B.INCIDENT_ADDRESS ,
B.INCIDENT_CITY ,
B.INCIDENT_STATE ,
B.INCIDENT_COUNTRY ,
B.INCIDENT_PROVINCE ,
B.INCIDENT_POSTAL_CODE ,
B.INCIDENT_COUNTY ,
B.CREDIT_CARD_NUMBER ,
B.CREDIT_CARD_TYPE_CODE ,
B.CREDIT_CARD_EXPIRATION_DATE ,
B.CREDIT_CARD_HOLDER_FNAME ,
B.CREDIT_CARD_HOLDER_MNAME ,
B.CREDIT_CARD_HOLDER_LNAME ,
B.CREDIT_CARD_ID ,
B.EXTERNAL_ATTRIBUTE_1 ,
B.EXTERNAL_ATTRIBUTE_2 ,
B.EXTERNAL_ATTRIBUTE_3 ,
B.EXTERNAL_ATTRIBUTE_4 ,
B.EXTERNAL_ATTRIBUTE_5 ,
B.EXTERNAL_ATTRIBUTE_6 ,
B.EXTERNAL_ATTRIBUTE_7 ,
B.EXTERNAL_ATTRIBUTE_8 ,
B.EXTERNAL_ATTRIBUTE_9 ,
B.EXTERNAL_ATTRIBUTE_10 ,
B.EXTERNAL_ATTRIBUTE_11 ,
B.EXTERNAL_ATTRIBUTE_12 ,
B.EXTERNAL_ATTRIBUTE_13 ,
B.EXTERNAL_ATTRIBUTE_14 ,
B.EXTERNAL_ATTRIBUTE_15 ,
B.EXTERNAL_CONTEXT ,
B.CUSTOMER_PHONE_ID ,
B.CUSTOMER_EMAIL_ID ,
B.BILL_TO_ACCOUNT_ID ,
B.SHIP_TO_ACCOUNT_ID ,
B.BILL_TO_PARTY_ID ,
B.SHIP_TO_PARTY_ID ,
B.BILL_TO_SITE_ID ,
B.SHIP_TO_SITE_ID ,
B.COVERAGE_TYPE ,
B.PROGRAM_LOGIN_ID ,
B.STATUS_FLAG ,
B.PRIMARY_CONTACT_ID ,
B.LAST_UPDATE_PROGRAM_CODE ,
B.CREATION_PROGRAM_CODE ,
B.INCIDENT_POINT_OF_INTEREST ,
B.INCIDENT_CROSS_STREET ,
B.INCIDENT_DIRECTION_QUALIFIER ,
B.INCIDENT_DISTANCE_QUALIFIER ,
B.INCIDENT_DISTANCE_QUAL_UOM ,
B.INCIDENT_ADDRESS2 ,
B.INCIDENT_ADDRESS3 ,
B.INCIDENT_ADDRESS4 ,
B.INCIDENT_ADDRESS_STYLE ,
B.INCIDENT_ADDR_LINES_PHONETIC ,
B.INCIDENT_PO_BOX_NUMBER ,
B.INCIDENT_HOUSE_NUMBER ,
B.INCIDENT_STREET_SUFFIX ,
B.INCIDENT_STREET ,
B.INCIDENT_STREET_NUMBER ,
B.INCIDENT_FLOOR ,
B.INCIDENT_SUITE ,
B.INCIDENT_POSTAL_PLUS4_CODE ,
B.INCIDENT_POSITION ,
B.INCIDENT_LOCATION_DIRECTIONS ,
B.INCIDENT_LOCATION_DESCRIPTION ,
B.INSTALL_SITE_ID ,
B.INCIDENT_LOCATION_TYPE ,
B.ITEM_SERIAL_NUMBER ,
B.OWNING_DEPARTMENT_ID ,
B.INCIDENT_LAST_MODIFIED_DATE ,
B.UNASSIGNED_INDICATOR ,
B.ESTIMATE_ID ,
B.ESTIMATE_BUSINESS_GROUP_ID ,
B.GROUP_TERRITORY_ID ,
B.OWNER_ASSIGNED_TIME ,
B.OWNER_ASSIGNED_FLAG,
B.MAINT_ORGANIZATION_ID
FROM
CS_INCIDENTS_B_SEC B,
CS_INCIDENTS_ALL_TL TL
WHERE
B.INCIDENT_ID = TL.INCIDENT_ID AND
TL.LANGUAGE = USERENV('LANG')
)
(
SELECT
B.ROWID ROW_ID
,
B.INCIDENT_ID
,
B.LAST_UPDATE_DATE
,
B.LAST_UPDATED_BY
,
B.CREATION_DATE
,
B.CREATED_BY
,
B.LAST_UPDATE_LOGIN
,
B.INCIDENT_NUMBER
,
B.INCIDENT_DATE
,
B.INCIDENT_STATUS_ID
,
B.INCIDENT_TYPE_ID
,
B.INCIDENT_URGENCY_ID
,
B.INCIDENT_SEVERITY_ID
,
B.INCIDENT_OWNER_ID
,
B.RESOURCE_TYPE
,
B.RESOURCE_SUBTYPE_ID
,
B.INVENTORY_ITEM_ID
,
B.CUSTOMER_ID
,
B.ACCOUNT_ID
,
B.BILL_TO_SITE_USE_ID
,
B.PURCHASE_ORDER_NUM
,
B.EMPLOYEE_ID
,
B.FILED_BY_EMPLOYEE_FLAG
,
B.SHIP_TO_SITE_USE_ID
,
B.PROBLEM_CODE
,
B.EXPECTED_RESOLUTION_DATE
,
B.ACTUAL_RESOLUTION_DATE
,
B.CUSTOMER_PRODUCT_ID
,
B.INSTALL_SITE_USE_ID
,
B.BILL_TO_CONTACT_ID
,
B.SHIP_TO_CONTACT_ID
,
B.CURRENT_SERIAL_NUMBER
,
B.CUSTOMER_NUMBER
,
B.SYSTEM_ID
,
B.INCIDENT_ATTRIBUTE_1
,
B.INCIDENT_ATTRIBUTE_2
,
B.INCIDENT_ATTRIBUTE_3
,
B.INCIDENT_ATTRIBUTE_4
,
B.INCIDENT_ATTRIBUTE_5
,
B.INCIDENT_ATTRIBUTE_6
,
B.INCIDENT_ATTRIBUTE_7
,
B.INCIDENT_ATTRIBUTE_8
,
B.INCIDENT_ATTRIBUTE_9
,
B.INCIDENT_ATTRIBUTE_10
,
B.INCIDENT_ATTRIBUTE_11
,
B.INCIDENT_ATTRIBUTE_12
,
B.INCIDENT_ATTRIBUTE_13
,
B.INCIDENT_ATTRIBUTE_14
,
B.INCIDENT_ATTRIBUTE_15
,
B.INCIDENT_CONTEXT
,
B.RECORD_IS_VALID_FLAG
,
B.RESOLUTION_CODE
,
B.ORG_ID
,
B.ORIGINAL_ORDER_NUMBER
,
B.WORKFLOW_PROCESS_ID
,
B.CLOSE_DATE
,
B.PUBLISH_FLAG
,
B.INTERFACED_TO_DEPOT_FLAG
,
B.QA_COLLECTION_ID
,
B.CONTRACT_SERVICE_ID
,
B.KB_TYPE
,
B.KB_SOLUTION_ID
,
B.TIME_ZONE_ID
,
B.TIME_DIFFERENCE
,
B.CUSTOMER_PO_NUMBER
,
B.OWNER_GROUP_ID
,
B.CUSTOMER_TICKET_NUMBER
,
B.OBLIGATION_DATE
,
B.SITE_ID
,
B.CUSTOMER_SITE_ID
,
B.CALLER_TYPE
,
B.PLATFORM_VERSION_ID
,
B.OBJECT_VERSION_NUMBER
,
TL.LANGUAGE
,
TL.SOURCE_LANG
,
TL.SUMMARY
,
B.SR_CREATION_CHANNEL
,
B.CP_COMPONENT_ID
,
B.CP_COMPONENT_VERSION_ID
,
B.CP_SUBCOMPONENT_ID
,
B.CP_SUBCOMPONENT_VERSION_ID
,
B.CP_REVISION_ID
,
B.INV_ITEM_REVISION
,
B.INV_COMPONENT_ID
,
B.INV_COMPONENT_VERSION
,
B.INV_SUBCOMPONENT_ID
,
B.INV_SUBCOMPONENT_VERSION
,
B.INV_ORGANIZATION_ID
,
B.PLATFORM_ID
,
B.LANGUAGE_ID
,
B.TERRITORY_ID
,
B.CONTRACT_NUMBER
,
B.CONTRACT_ID
,
B.PROJECT_NUMBER
,
B.CUST_PREF_LANG_ID
,
B.PLATFORM_VERSION
,
B.TIER
,
B.TIER_VERSION
,
B.CATEGORY_ID
,
B.OPERATING_SYSTEM
,
B.OPERATING_SYSTEM_VERSION
,
B.DATABASE
,
B.DB_VERSION
,
B.GROUP_TYPE
,
B.INV_PLATFORM_ORG_ID
,
B.PRODUCT_REVISION
,
B.COMPONENT_VERSION
,
B.SUBCOMPONENT_VERSION
,
B.COMM_PREF_CODE
,
B.LAST_UPDATE_CHANNEL
,
B.CUST_PREF_LANG_CODE
,
B.ERROR_CODE
,
B.CATEGORY_SET_ID
,
B.EXTERNAL_REFERENCE
,
B.INCIDENT_OCCURRED_DATE
,
B.INCIDENT_RESOLVED_DATE
,
B.INC_RESPONDED_BY_DATE
,
TL.GROUP_OWNER
,
TL.OWNER
,
TL.RESOLUTION_SUMMARY
,
B.INCIDENT_LOCATION_ID
,
B.INCIDENT_ADDRESS
,
B.INCIDENT_CITY
,
B.INCIDENT_STATE
,
B.INCIDENT_COUNTRY
,
B.INCIDENT_PROVINCE
,
B.INCIDENT_POSTAL_CODE
,
B.INCIDENT_COUNTY
,
B.CREDIT_CARD_NUMBER
,
B.CREDIT_CARD_TYPE_CODE
,
B.CREDIT_CARD_EXPIRATION_DATE
,
B.CREDIT_CARD_HOLDER_FNAME
,
B.CREDIT_CARD_HOLDER_MNAME
,
B.CREDIT_CARD_HOLDER_LNAME
,
B.CREDIT_CARD_ID
,
B.EXTERNAL_ATTRIBUTE_1
,
B.EXTERNAL_ATTRIBUTE_2
,
B.EXTERNAL_ATTRIBUTE_3
,
B.EXTERNAL_ATTRIBUTE_4
,
B.EXTERNAL_ATTRIBUTE_5
,
B.EXTERNAL_ATTRIBUTE_6
,
B.EXTERNAL_ATTRIBUTE_7
,
B.EXTERNAL_ATTRIBUTE_8
,
B.EXTERNAL_ATTRIBUTE_9
,
B.EXTERNAL_ATTRIBUTE_10
,
B.EXTERNAL_ATTRIBUTE_11
,
B.EXTERNAL_ATTRIBUTE_12
,
B.EXTERNAL_ATTRIBUTE_13
,
B.EXTERNAL_ATTRIBUTE_14
,
B.EXTERNAL_ATTRIBUTE_15
,
B.EXTERNAL_CONTEXT
,
B.CUSTOMER_PHONE_ID
,
B.CUSTOMER_EMAIL_ID
,
B.BILL_TO_ACCOUNT_ID
,
B.SHIP_TO_ACCOUNT_ID
,
B.BILL_TO_PARTY_ID
,
B.SHIP_TO_PARTY_ID
,
B.BILL_TO_SITE_ID
,
B.SHIP_TO_SITE_ID
,
B.COVERAGE_TYPE
,
B.PROGRAM_LOGIN_ID
,
B.STATUS_FLAG
,
B.PRIMARY_CONTACT_ID
,
B.LAST_UPDATE_PROGRAM_CODE
,
B.CREATION_PROGRAM_CODE
,
B.INCIDENT_POINT_OF_INTEREST
,
B.INCIDENT_CROSS_STREET
,
B.INCIDENT_DIRECTION_QUALIFIER
,
B.INCIDENT_DISTANCE_QUALIFIER
,
B.INCIDENT_DISTANCE_QUAL_UOM
,
B.INCIDENT_ADDRESS2
,
B.INCIDENT_ADDRESS3
,
B.INCIDENT_ADDRESS4
,
B.INCIDENT_ADDRESS_STYLE
,
B.INCIDENT_ADDR_LINES_PHONETIC
,
B.INCIDENT_PO_BOX_NUMBER
,
B.INCIDENT_HOUSE_NUMBER
,
B.INCIDENT_STREET_SUFFIX
,
B.INCIDENT_STREET
,
B.INCIDENT_STREET_NUMBER
,
B.INCIDENT_FLOOR
,
B.INCIDENT_SUITE
,
B.INCIDENT_POSTAL_PLUS4_CODE
,
B.INCIDENT_POSITION
,
B.INCIDENT_LOCATION_DIRECTIONS
,
B.INCIDENT_LOCATION_DESCRIPTION
,
B.INSTALL_SITE_ID
,
B.INCIDENT_LOCATION_TYPE
,
B.ITEM_SERIAL_NUMBER
,
B.OWNING_DEPARTMENT_ID
,
B.INCIDENT_LAST_MODIFIED_DATE
,
B.UNASSIGNED_INDICATOR
,
B.ESTIMATE_ID
,
B.ESTIMATE_BUSINESS_GROUP_ID
,
B.GROUP_TERRITORY_ID
,
B.OWNER_ASSIGNED_TIME
,
B.OWNER_ASSIGNED_FLAG
,
B.MAINT_ORGANIZATION_ID
FROM
CS_INCIDENTS_B_SEC B
,
CS_INCIDENTS_ALL_TL TL
WHERE
B.INCIDENT_ID = TL.INCIDENT_ID AND
TL.LANGUAGE = USERENV('LANG')
)
|
|
|