[Home] [Help] [Dependency Information]
Object Name: | CS_INCIDENTS_AUDIT_B# |
---|---|
Object Type: | VIEW |
Owner: | CS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INCIDENT_ID | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATION_TIME | VARCHAR2 | (30) | ||
INCIDENT_STATUS_ID | NUMBER | (15) | ||
OLD_INCIDENT_STATUS_ID | NUMBER | (15) | ||
CHANGE_INCIDENT_STATUS_FLAG | VARCHAR2 | (1) | ||
INCIDENT_TYPE_ID | NUMBER | (15) | ||
OLD_INCIDENT_TYPE_ID | NUMBER | (15) | ||
CHANGE_INCIDENT_TYPE_FLAG | VARCHAR2 | (1) | ||
INCIDENT_URGENCY_ID | NUMBER | (15) | ||
OLD_INCIDENT_URGENCY_ID | NUMBER | (15) | ||
CHANGE_INCIDENT_URGENCY_FLAG | VARCHAR2 | (1) | ||
INCIDENT_SEVERITY_ID | NUMBER | (15) | ||
OLD_INCIDENT_SEVERITY_ID | NUMBER | (15) | ||
CHANGE_INCIDENT_SEVERITY_FLAG | VARCHAR2 | (1) | ||
RESPONSIBLE_GROUP_ID | NUMBER | (15) | ||
OLD_RESPONSIBLE_GROUP_ID | NUMBER | (15) | ||
CHANGE_RESPONSIBLE_GROUP_FLAG | VARCHAR2 | (1) | ||
INCIDENT_OWNER_ID | NUMBER | (15) | ||
OLD_INCIDENT_OWNER_ID | NUMBER | (15) | ||
CHANGE_INCIDENT_OWNER_FLAG | VARCHAR2 | (1) | ||
CREATE_MANUAL_ACTION | VARCHAR2 | (1) | ||
ACTION_ID | NUMBER | (15) | ||
EXPECTED_RESOLUTION_DATE | DATE | |||
OLD_EXPECTED_RESOLUTION_DATE | DATE | |||
CHANGE_RESOLUTION_FLAG | VARCHAR2 | (1) | ||
INCIDENT_AUDIT_ID | NUMBER | (15) | Yes | |
CHANGE_DESCRIPTION | VARCHAR2 | (2000) | ||
NEW_WORKFLOW_FLAG | VARCHAR2 | (1) | ||
WORKFLOW_PROCESS_NAME | VARCHAR2 | (30) | ||
WORKFLOW_PROCESS_ITEMKEY | VARCHAR2 | (240) | ||
GROUP_ID | NUMBER | |||
OLD_GROUP_ID | NUMBER | |||
CHANGE_GROUP_FLAG | VARCHAR2 | (1) | ||
OBLIGATION_DATE | DATE | |||
OLD_OBLIGATION_DATE | DATE | |||
CHANGE_OBLIGATION_FLAG | VARCHAR2 | (1) | ||
SITE_ID | NUMBER | |||
OLD_SITE_ID | NUMBER | |||
CHANGE_SITE_FLAG | VARCHAR2 | (1) | ||
BILL_TO_CONTACT_ID | NUMBER | (15) | ||
OLD_BILL_TO_CONTACT_ID | NUMBER | (15) | ||
CHANGE_BILL_TO_FLAG | VARCHAR2 | (1) | ||
SHIP_TO_CONTACT_ID | NUMBER | (15) | ||
OLD_SHIP_TO_CONTACT_ID | NUMBER | (15) | ||
CHANGE_SHIP_TO_FLAG | VARCHAR2 | (1) | ||
INCIDENT_DATE | DATE | |||
OLD_INCIDENT_DATE | DATE | |||
CHANGE_INCIDENT_DATE_FLAG | VARCHAR2 | (1) | ||
CLOSE_DATE | DATE | |||
OLD_CLOSE_DATE | DATE | |||
CHANGE_CLOSE_DATE_FLAG | VARCHAR2 | (1) | ||
CUSTOMER_PRODUCT_ID | NUMBER | (15) | ||
OLD_CUSTOMER_PRODUCT_ID | NUMBER | (15) | ||
CHANGE_CUSTOMER_PRODUCT_FLAG | VARCHAR2 | (1) | ||
AUDIT_FIELD | VARCHAR2 | (30) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
PLATFORM_ID | NUMBER | |||
OLD_PLATFORM_ID | NUMBER | |||
CHANGE_PLATFORM_ID_FLAG | VARCHAR2 | (1) | ||
PLATFORM_VERSION_ID | NUMBER | |||
OLD_PLATFORM_VERSION_ID | NUMBER | |||
CHANGE_PLAT_VER_ID_FLAG | VARCHAR2 | (1) | ||
CP_COMPONENT_ID | NUMBER | |||
OLD_CP_COMPONENT_ID | NUMBER | |||
CHANGE_CP_COMPONENT_ID_FLAG | VARCHAR2 | (1) | ||
CP_COMPONENT_VERSION_ID | NUMBER | |||
OLD_CP_COMPONENT_VERSION_ID | NUMBER | |||
CHANGE_CP_COMP_VER_ID_FLAG | VARCHAR2 | (1) | ||
CP_SUBCOMPONENT_ID | NUMBER | |||
OLD_CP_SUBCOMPONENT_ID | NUMBER | |||
CHANGE_CP_SUBCOMPONENT_ID_FLAG | VARCHAR2 | (1) | ||
CP_SUBCOMPONENT_VERSION_ID | NUMBER | |||
OLD_CP_SUBCOMPONENT_VERSION_ID | NUMBER | |||
CHANGE_CP_SUBCOMP_VER_ID_FLAG | VARCHAR2 | (1) | ||
LANGUAGE_ID | NUMBER | |||
OLD_LANGUAGE_ID | NUMBER | |||
CHANGE_LANGUAGE_ID_FLAG | VARCHAR2 | (1) | ||
TERRITORY_ID | NUMBER | |||
OLD_TERRITORY_ID | NUMBER | |||
CHANGE_TERRITORY_ID_FLAG | VARCHAR2 | (1) | ||
CP_REVISION_ID | NUMBER | |||
OLD_CP_REVISION_ID | NUMBER | |||
CHANGE_CP_REVISION_ID_FLAG | VARCHAR2 | (1) | ||
INV_ITEM_REVISION | VARCHAR2 | (240) | ||
OLD_INV_ITEM_REVISION | VARCHAR2 | (240) | ||
CHANGE_INV_ITEM_REVISION | VARCHAR2 | (1) | ||
INV_COMPONENT_ID | NUMBER | |||
OLD_INV_COMPONENT_ID | NUMBER | |||
CHANGE_INV_COMPONENT_ID | VARCHAR2 | (1) | ||
INV_COMPONENT_VERSION | VARCHAR2 | (90) | ||
OLD_INV_COMPONENT_VERSION | VARCHAR2 | (90) | ||
CHANGE_INV_COMPONENT_VERSION | VARCHAR2 | (1) | ||
INV_SUBCOMPONENT_ID | NUMBER | |||
OLD_INV_SUBCOMPONENT_ID | NUMBER | |||
CHANGE_INV_SUBCOMPONENT_ID | VARCHAR2 | (1) | ||
INV_SUBCOMPONENT_VERSION | VARCHAR2 | (90) | ||
OLD_INV_SUBCOMPONENT_VERSION | VARCHAR2 | (90) | ||
CHANGE_INV_SUBCOMP_VERSION | VARCHAR2 | (1) | ||
RESOURCE_TYPE | VARCHAR2 | (30) | ||
OLD_RESOURCE_TYPE | VARCHAR2 | (30) | ||
CHANGE_RESOURCE_TYPE_FLAG | VARCHAR2 | (1) | ||
SECURITY_GROUP_ID | NUMBER | |||
UPGRADED_STATUS_FLAG | VARCHAR2 | (1) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
OLD_GROUP_TYPE | VARCHAR2 | (30) | ||
GROUP_TYPE | VARCHAR2 | (30) | ||
CHANGE_GROUP_TYPE_FLAG | VARCHAR2 | (1) | ||
OLD_OWNER_ASSIGNED_TIME | DATE | |||
OWNER_ASSIGNED_TIME | DATE | |||
CHANGE_ASSIGNED_TIME_FLAG | VARCHAR2 | (1) | ||
INV_PLATFORM_ORG_ID | NUMBER | |||
OLD_INV_PLATFORM_ORG_ID | NUMBER | |||
CHANGE_PLATFORM_ORG_ID_FLAG | VARCHAR2 | (1) | ||
COMPONENT_VERSION | VARCHAR2 | (3) | ||
OLD_COMPONENT_VERSION | VARCHAR2 | (3) | ||
CHANGE_COMP_VER_FLAG | VARCHAR2 | (1) | ||
SUBCOMPONENT_VERSION | VARCHAR2 | (3) | ||
OLD_SUBCOMPONENT_VERSION | VARCHAR2 | (3) | ||
CHANGE_SUBCOMP_VER_FLAG | VARCHAR2 | (1) | ||
PRODUCT_REVISION | VARCHAR2 | (240) | ||
OLD_PRODUCT_REVISION | VARCHAR2 | (240) | ||
CHANGE_PRODUCT_REVISION_FLAG | VARCHAR2 | (1) | ||
STATUS_FLAG | VARCHAR2 | (3) | ||
OLD_STATUS_FLAG | VARCHAR2 | (3) | ||
CHANGE_STATUS_FLAG | VARCHAR2 | (3) | ||
INVENTORY_ITEM_ID | NUMBER | (15) | ||
OLD_INVENTORY_ITEM_ID | NUMBER | (15) | ||
CHANGE_INVENTORY_ITEM_FLAG | VARCHAR2 | (3) | ||
INV_ORGANIZATION_ID | NUMBER | |||
OLD_INV_ORGANIZATION_ID | NUMBER | |||
CHANGE_INV_ORGANIZATION_FLAG | VARCHAR2 | (3) | ||
PRIMARY_CONTACT_ID | NUMBER | |||
OLD_PRIMARY_CONTACT_ID | NUMBER | |||
CHANGE_PRIMARY_CONTACT_FLAG | VARCHAR2 | (3) | ||
UPGRADE_FLAG_FOR_CREATE | VARCHAR2 | (1) | ||
OLD_INCIDENT_NUMBER | VARCHAR2 | (64) | ||
INCIDENT_NUMBER | VARCHAR2 | (64) | ||
OLD_CUSTOMER_ID | NUMBER | (15) | ||
CUSTOMER_ID | NUMBER | (15) | ||
OLD_BILL_TO_SITE_USE_ID | NUMBER | (15) | ||
BILL_TO_SITE_USE_ID | NUMBER | (15) | ||
OLD_EMPLOYEE_ID | NUMBER | (15) | ||
EMPLOYEE_ID | NUMBER | (15) | ||
OLD_SHIP_TO_SITE_USE_ID | NUMBER | (15) | ||
SHIP_TO_SITE_USE_ID | NUMBER | (15) | ||
OLD_PROBLEM_CODE | VARCHAR2 | (50) | ||
PROBLEM_CODE | VARCHAR2 | (50) | ||
OLD_ACTUAL_RESOLUTION_DATE | DATE | |||
ACTUAL_RESOLUTION_DATE | DATE | |||
OLD_INSTALL_SITE_USE_ID | NUMBER | (15) | ||
INSTALL_SITE_USE_ID | NUMBER | (15) | ||
OLD_CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | ||
CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | ||
OLD_SYSTEM_ID | NUMBER | (15) | ||
SYSTEM_ID | NUMBER | (15) | ||
OLD_INCIDENT_ATTRIBUTE_1 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_1 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_2 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_2 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_3 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_3 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_4 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_4 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_5 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_5 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_6 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_6 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_7 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_7 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_8 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_8 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_9 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_9 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_10 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_10 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_11 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_11 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_12 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_12 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_13 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_13 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_14 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_14 | VARCHAR2 | (150) | ||
OLD_INCIDENT_ATTRIBUTE_15 | VARCHAR2 | (150) | ||
INCIDENT_ATTRIBUTE_15 | VARCHAR2 | (150) | ||
OLD_INCIDENT_CONTEXT | VARCHAR2 | (30) | ||
INCIDENT_CONTEXT | VARCHAR2 | (30) | ||
OLD_RESOLUTION_CODE | VARCHAR2 | (50) | ||
RESOLUTION_CODE | VARCHAR2 | (50) | ||
OLD_ORIGINAL_ORDER_NUMBER | NUMBER | |||
ORIGINAL_ORDER_NUMBER | NUMBER | |||
OLD_ORG_ID | NUMBER | |||
ORG_ID | NUMBER | |||
OLD_PURCHASE_ORDER_NUMBER | VARCHAR2 | (50) | ||
PURCHASE_ORDER_NUMBER | VARCHAR2 | (50) | ||
OLD_PUBLISH_FLAG | VARCHAR2 | (1) | ||
PUBLISH_FLAG | VARCHAR2 | (1) | ||
OLD_QA_COLLECTION_ID | NUMBER | |||
QA_COLLECTION_ID | NUMBER | |||
OLD_CONTRACT_ID | NUMBER | |||
CONTRACT_ID | NUMBER | |||
OLD_CONTRACT_NUMBER | VARCHAR2 | (120) | ||
CONTRACT_NUMBER | VARCHAR2 | (120) | ||
OLD_CONTRACT_SERVICE_ID | NUMBER | |||
CONTRACT_SERVICE_ID | NUMBER | |||
OLD_TIME_ZONE_ID | NUMBER | (15) | ||
TIME_ZONE_ID | NUMBER | (15) | ||
OLD_ACCOUNT_ID | NUMBER | |||
ACCOUNT_ID | NUMBER | |||
OLD_TIME_DIFFERENCE | NUMBER | |||
TIME_DIFFERENCE | NUMBER | |||
OLD_CUSTOMER_PO_NUMBER | VARCHAR2 | (50) | ||
CUSTOMER_PO_NUMBER | VARCHAR2 | (50) | ||
OLD_CUSTOMER_TICKET_NUMBER | VARCHAR2 | (50) | ||
CUSTOMER_TICKET_NUMBER | VARCHAR2 | (50) | ||
OLD_CUSTOMER_SITE_ID | NUMBER | |||
CUSTOMER_SITE_ID | NUMBER | |||
OLD_CALLER_TYPE | VARCHAR2 | (30) | ||
CALLER_TYPE | VARCHAR2 | (30) | ||
OLD_INC_OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
INC_OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
OLD_SECURITY_GROUP_ID | NUMBER | (15) | ||
OLD_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (60) | ||
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (60) | ||
OLD_ORIG_SYSTEM_REFERENCE_ID | NUMBER | |||
ORIG_SYSTEM_REFERENCE_ID | NUMBER | |||
OLD_INC_REQUEST_ID | NUMBER | |||
INC_REQUEST_ID | NUMBER | |||
OLD_INC_PROGRAM_APPLICATION_ID | NUMBER | |||
INC_PROGRAM_APPLICATION_ID | NUMBER | |||
OLD_INC_PROGRAM_ID | NUMBER | |||
INC_PROGRAM_ID | NUMBER | |||
OLD_INC_PROGRAM_UPDATE_DATE | DATE | |||
INC_PROGRAM_UPDATE_DATE | DATE | |||
OLD_PROJECT_NUMBER | VARCHAR2 | (120) | ||
PROJECT_NUMBER | VARCHAR2 | (120) | ||
OLD_PLATFORM_VERSION | VARCHAR2 | (250) | ||
PLATFORM_VERSION | VARCHAR2 | (250) | ||
OLD_DB_VERSION | VARCHAR2 | (250) | ||
DB_VERSION | VARCHAR2 | (250) | ||
OLD_CUST_PREF_LANG_ID | NUMBER | |||
CUST_PREF_LANG_ID | NUMBER | |||
OLD_TIER | VARCHAR2 | (250) | ||
TIER | VARCHAR2 | (250) | ||
OLD_TIER_VERSION | VARCHAR2 | (250) | ||
TIER_VERSION | VARCHAR2 | (250) | ||
OLD_CATEGORY_ID | NUMBER | |||
CATEGORY_ID | NUMBER | |||
OLD_OPERATING_SYSTEM | VARCHAR2 | (250) | ||
OPERATING_SYSTEM | VARCHAR2 | (250) | ||
OLD_OPERATING_SYSTEM_VERSION | VARCHAR2 | (250) | ||
OPERATING_SYSTEM_VERSION | VARCHAR2 | (250) | ||
OLD_DATABASE | VARCHAR2 | (250) | ||
DATABASE | VARCHAR2 | (250) | ||
OLD_GROUP_TERRITORY_ID | NUMBER | |||
GROUP_TERRITORY_ID | NUMBER | |||
OLD_COMM_PREF_CODE | VARCHAR2 | (30) | ||
COMM_PREF_CODE | VARCHAR2 | (30) | ||
OLD_LAST_UPDATE_CHANNEL | VARCHAR2 | (10) | ||
LAST_UPDATE_CHANNEL | VARCHAR2 | (10) | ||
OLD_CUST_PREF_LANG_CODE | VARCHAR2 | (4) | ||
CUST_PREF_LANG_CODE | VARCHAR2 | (4) | ||
OLD_ERROR_CODE | VARCHAR2 | (250) | ||
ERROR_CODE | VARCHAR2 | (250) | ||
OLD_CATEGORY_SET_ID | NUMBER | |||
CATEGORY_SET_ID | NUMBER | |||
OLD_EXTERNAL_REFERENCE | VARCHAR2 | (30) | ||
EXTERNAL_REFERENCE | VARCHAR2 | (30) | ||
OLD_INCIDENT_OCCURRED_DATE | DATE | |||
INCIDENT_OCCURRED_DATE | DATE | |||
OLD_INCIDENT_RESOLVED_DATE | DATE | |||
INCIDENT_RESOLVED_DATE | DATE | |||
OLD_INC_RESPONDED_BY_DATE | DATE | |||
INC_RESPONDED_BY_DATE | DATE | |||
OLD_INCIDENT_LOCATION_ID | NUMBER | |||
INCIDENT_LOCATION_ID | NUMBER | |||
OLD_INCIDENT_ADDRESS | VARCHAR2 | (960) | ||
INCIDENT_ADDRESS | VARCHAR2 | (960) | ||
OLD_INCIDENT_CITY | VARCHAR2 | (60) | ||
INCIDENT_CITY | VARCHAR2 | (60) | ||
OLD_INCIDENT_STATE | VARCHAR2 | (60) | ||
INCIDENT_STATE | VARCHAR2 | (60) | ||
OLD_INCIDENT_COUNTRY | VARCHAR2 | (60) | ||
INCIDENT_COUNTRY | VARCHAR2 | (60) | ||
OLD_INCIDENT_PROVINCE | VARCHAR2 | (60) | ||
INCIDENT_PROVINCE | VARCHAR2 | (60) | ||
OLD_INCIDENT_POSTAL_CODE | VARCHAR2 | (60) | ||
INCIDENT_POSTAL_CODE | VARCHAR2 | (60) | ||
OLD_INCIDENT_COUNTY | VARCHAR2 | (60) | ||
INCIDENT_COUNTY | VARCHAR2 | (60) | ||
OLD_SR_CREATION_CHANNEL | VARCHAR2 | (50) | ||
SR_CREATION_CHANNEL | VARCHAR2 | (50) | ||
OLD_DEF_DEFECT_ID | NUMBER | |||
DEF_DEFECT_ID | NUMBER | |||
OLD_DEF_DEFECT_ID2 | NUMBER | |||
DEF_DEFECT_ID2 | NUMBER | |||
OLD_CREDIT_CARD_NUMBER | VARCHAR2 | (48) | ||
CREDIT_CARD_NUMBER | VARCHAR2 | (48) | ||
OLD_CREDIT_CARD_TYPE_CODE | VARCHAR2 | (30) | ||
CREDIT_CARD_TYPE_CODE | VARCHAR2 | (30) | ||
OLD_CREDIT_CARD_EXPIRATION_DT | DATE | |||
CREDIT_CARD_EXPIRATION_DT | DATE | |||
OLD_CREDIT_CARD_HOLDER_FNAME | VARCHAR2 | (250) | ||
CREDIT_CARD_HOLDER_FNAME | VARCHAR2 | (250) | ||
OLD_CREDIT_CARD_HOLDER_MNAME | VARCHAR2 | (250) | ||
CREDIT_CARD_HOLDER_MNAME | VARCHAR2 | (250) | ||
OLD_CREDIT_CARD_HOLDER_LNAME | VARCHAR2 | (250) | ||
CREDIT_CARD_HOLDER_LNAME | VARCHAR2 | (250) | ||
OLD_CREDIT_CARD_ID | NUMBER | |||
CREDIT_CARD_ID | NUMBER | |||
OLD_EXTERNAL_ATTRIBUTE_1 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_1 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_2 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_2 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_3 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_3 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_4 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_4 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_5 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_5 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_6 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_6 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_7 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_7 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_8 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_8 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_9 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_9 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_10 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_10 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_11 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_11 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_12 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_12 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_13 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_13 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_14 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_14 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_ATTRIBUTE_15 | VARCHAR2 | (150) | ||
EXTERNAL_ATTRIBUTE_15 | VARCHAR2 | (150) | ||
OLD_EXTERNAL_CONTEXT | VARCHAR2 | (30) | ||
EXTERNAL_CONTEXT | VARCHAR2 | (30) | ||
OLD_LAST_UPDATE_PROGRAM_CODE | VARCHAR2 | (30) | ||
LAST_UPDATE_PROGRAM_CODE | VARCHAR2 | (30) | ||
OLD_CREATION_PROGRAM_CODE | VARCHAR2 | (30) | ||
CREATION_PROGRAM_CODE | VARCHAR2 | (30) | ||
OLD_COVERAGE_TYPE | VARCHAR2 | (30) | ||
COVERAGE_TYPE | VARCHAR2 | (30) | ||
OLD_BILL_TO_ACCOUNT_ID | NUMBER | (15) | ||
BILL_TO_ACCOUNT_ID | NUMBER | (15) | ||
OLD_SHIP_TO_ACCOUNT_ID | NUMBER | (15) | ||
SHIP_TO_ACCOUNT_ID | NUMBER | (15) | ||
OLD_CUSTOMER_EMAIL_ID | NUMBER | (15) | ||
CUSTOMER_EMAIL_ID | NUMBER | (15) | ||
OLD_CUSTOMER_PHONE_ID | NUMBER | (15) | ||
CUSTOMER_PHONE_ID | NUMBER | (15) | ||
OLD_BILL_TO_PARTY_ID | NUMBER | |||
BILL_TO_PARTY_ID | NUMBER | |||
OLD_SHIP_TO_PARTY_ID | NUMBER | |||
SHIP_TO_PARTY_ID | NUMBER | |||
OLD_BILL_TO_SITE_ID | NUMBER | |||
BILL_TO_SITE_ID | NUMBER | |||
OLD_SHIP_TO_SITE_ID | NUMBER | |||
SHIP_TO_SITE_ID | NUMBER | |||
OLD_PROGRAM_LOGIN_ID | NUMBER | |||
PROGRAM_LOGIN_ID | NUMBER | |||
OLD_INCIDENT_POINT_OF_INTEREST | VARCHAR2 | (240) | ||
INCIDENT_POINT_OF_INTEREST | VARCHAR2 | (240) | ||
OLD_INCIDENT_CROSS_STREET | VARCHAR2 | (240) | ||
INCIDENT_CROSS_STREET | VARCHAR2 | (240) | ||
OLD_INCIDENT_DIRECTION_QUALIF | VARCHAR2 | (30) | ||
INCIDENT_DIRECTION_QUALIF | VARCHAR2 | (30) | ||
OLD_INCIDENT_DISTANCE_QUALIF | VARCHAR2 | (240) | ||
INCIDENT_DISTANCE_QUALIF | VARCHAR2 | (240) | ||
OLD_INCIDENT_DISTANCE_QUAL_UOM | VARCHAR2 | (30) | ||
INCIDENT_DISTANCE_QUAL_UOM | VARCHAR2 | (30) | ||
OLD_INCIDENT_ADDRESS2 | VARCHAR2 | (240) | ||
INCIDENT_ADDRESS2 | VARCHAR2 | (240) | ||
OLD_INCIDENT_ADDRESS3 | VARCHAR2 | (240) | ||
INCIDENT_ADDRESS3 | VARCHAR2 | (240) | ||
OLD_INCIDENT_ADDRESS4 | VARCHAR2 | (240) | ||
INCIDENT_ADDRESS4 | VARCHAR2 | (240) | ||
OLD_INCIDENT_ADDRESS_STYLE | VARCHAR2 | (30) | ||
INCIDENT_ADDRESS_STYLE | VARCHAR2 | (30) | ||
OLD_INCIDENT_ADDR_LNS_PHONETIC | VARCHAR2 | (560) | ||
INCIDENT_ADDR_LNS_PHONETIC | VARCHAR2 | (560) | ||
OLD_INCIDENT_PO_BOX_NUMBER | VARCHAR2 | (50) | ||
INCIDENT_PO_BOX_NUMBER | VARCHAR2 | (50) | ||
OLD_INCIDENT_HOUSE_NUMBER | VARCHAR2 | (50) | ||
INCIDENT_HOUSE_NUMBER | VARCHAR2 | (50) | ||
OLD_INCIDENT_STREET_SUFFIX | VARCHAR2 | (50) | ||
INCIDENT_STREET_SUFFIX | VARCHAR2 | (50) | ||
OLD_INCIDENT_STREET | VARCHAR2 | (150) | ||
INCIDENT_STREET | VARCHAR2 | (150) | ||
OLD_INCIDENT_STREET_NUMBER | VARCHAR2 | (50) | ||
INCIDENT_STREET_NUMBER | VARCHAR2 | (50) | ||
OLD_INCIDENT_FLOOR | VARCHAR2 | (50) | ||
INCIDENT_FLOOR | VARCHAR2 | (50) | ||
OLD_INCIDENT_SUITE | VARCHAR2 | (50) | ||
INCIDENT_SUITE | VARCHAR2 | (50) | ||
OLD_INCIDENT_POSTAL_PLUS4_CODE | VARCHAR2 | (30) | ||
INCIDENT_POSTAL_PLUS4_CODE | VARCHAR2 | (30) | ||
OLD_INCIDENT_POSITION | VARCHAR2 | (50) | ||
INCIDENT_POSITION | VARCHAR2 | (50) | ||
OLD_INCIDENT_LOC_DIRECTIONS | VARCHAR2 | (640) | ||
INCIDENT_LOC_DIRECTIONS | VARCHAR2 | (640) | ||
OLD_INCIDENT_LOC_DESCRIPTION | VARCHAR2 | (2000) | ||
INCIDENT_LOC_DESCRIPTION | VARCHAR2 | (2000) | ||
OLD_INSTALL_SITE_ID | NUMBER | |||
INSTALL_SITE_ID | NUMBER | |||
INCIDENT_LAST_MODIFIED_DATE | DATE | |||
UPDATED_ENTITY_CODE | VARCHAR2 | (30) | ||
UPDATED_ENTITY_ID | NUMBER | |||
ENTITY_ACTIVITY_CODE | VARCHAR2 | (30) | ||
OLD_OWNING_DEPARTMENT_ID | NUMBER | |||
OWNING_DEPARTMENT_ID | NUMBER | |||
OLD_ITEM_SERIAL_NUMBER | VARCHAR2 | (30) | ||
ITEM_SERIAL_NUMBER | VARCHAR2 | (30) | ||
OLD_INCIDENT_LOCATION_TYPE | VARCHAR2 | (30) | ||
INCIDENT_LOCATION_TYPE | VARCHAR2 | (30) | ||
OLD_UNASSIGNED_INDICATOR | VARCHAR2 | (1) | ||
UNASSIGNED_INDICATOR | VARCHAR2 | (1) | ||
OLD_OWNER_ASSIGNED_FLAG | VARCHAR2 | (1) | ||
OWNER_ASSIGNED_FLAG | VARCHAR2 | (1) | ||
OLD_MAINT_ORGANIZATION_ID | NUMBER | |||
MAINT_ORGANIZATION_ID | NUMBER | |||
PROJECT_ID | NUMBER | (15) | ||
OLD_PROJECT_ID | NUMBER | (15) | ||
PROJECT_TASK_ID | NUMBER | (15) | ||
OLD_PROJECT_TASK_ID | NUMBER | (15) | ||
OLD_PRICE_LIST_HEADER_ID | NUMBER | |||
PRICE_LIST_HEADER_ID | NUMBER | |||
OLD_EXPENDITURE_ORG_ID | NUMBER | |||
EXPENDITURE_ORG_ID | NUMBER | |||
CHANGE_SLA_DATE_1_FLAG | VARCHAR2 | (1) | ||
OLD_SLA_DATE_1 | DATE | |||
SLA_DATE_1 | DATE | |||
CHANGE_SLA_DATE_2_FLAG | VARCHAR2 | (1) | ||
OLD_SLA_DATE_2 | DATE | |||
SLA_DATE_2 | DATE | |||
CHANGE_SLA_DATE_3_FLAG | VARCHAR2 | (1) | ||
OLD_SLA_DATE_3 | DATE | |||
SLA_DATE_3 | DATE | |||
CHANGE_SLA_DATE_4_FLAG | VARCHAR2 | (1) | ||
OLD_SLA_DATE_4 | DATE | |||
SLA_DATE_4 | DATE | |||
CHANGE_SLA_DATE_5_FLAG | VARCHAR2 | (1) | ||
OLD_SLA_DATE_5 | DATE | |||
SLA_DATE_5 | DATE | |||
CHANGE_SLA_DATE_6_FLAG | VARCHAR2 | (1) | ||
OLD_SLA_DATE_6 | DATE | |||
SLA_DATE_6 | DATE | |||
CHANGE_SLA_DURATION_1_FLAG | VARCHAR2 | (1) | ||
OLD_SLA_DURATION_1 | NUMBER | (15) | ||
SLA_DURATION_1 | NUMBER | (15) | ||
CHANGE_SLA_DURATION_2_FLAG | VARCHAR2 | (1) | ||
OLD_SLA_DURATION_2 | NUMBER | (15) | ||
SLA_DURATION_2 | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT INCIDENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CREATION_TIME
, INCIDENT_STATUS_ID
, OLD_INCIDENT_STATUS_ID
, CHANGE_INCIDENT_STATUS_FLAG
, INCIDENT_TYPE_ID
, OLD_INCIDENT_TYPE_ID
, CHANGE_INCIDENT_TYPE_FLAG
, INCIDENT_URGENCY_ID
, OLD_INCIDENT_URGENCY_ID
, CHANGE_INCIDENT_URGENCY_FLAG
, INCIDENT_SEVERITY_ID
, OLD_INCIDENT_SEVERITY_ID
, CHANGE_INCIDENT_SEVERITY_FLAG
, RESPONSIBLE_GROUP_ID
, OLD_RESPONSIBLE_GROUP_ID
, CHANGE_RESPONSIBLE_GROUP_FLAG
, INCIDENT_OWNER_ID
, OLD_INCIDENT_OWNER_ID
, CHANGE_INCIDENT_OWNER_FLAG
, CREATE_MANUAL_ACTION
, ACTION_ID
, EXPECTED_RESOLUTION_DATE
, OLD_EXPECTED_RESOLUTION_DATE
, CHANGE_RESOLUTION_FLAG
, INCIDENT_AUDIT_ID
, CHANGE_DESCRIPTION
, NEW_WORKFLOW_FLAG
, WORKFLOW_PROCESS_NAME
, WORKFLOW_PROCESS_ITEMKEY
, GROUP_ID
, OLD_GROUP_ID
, CHANGE_GROUP_FLAG
, OBLIGATION_DATE
, OLD_OBLIGATION_DATE
, CHANGE_OBLIGATION_FLAG
, SITE_ID
, OLD_SITE_ID
, CHANGE_SITE_FLAG
, BILL_TO_CONTACT_ID
, OLD_BILL_TO_CONTACT_ID
, CHANGE_BILL_TO_FLAG
, SHIP_TO_CONTACT_ID
, OLD_SHIP_TO_CONTACT_ID
, CHANGE_SHIP_TO_FLAG
, INCIDENT_DATE
, OLD_INCIDENT_DATE
, CHANGE_INCIDENT_DATE_FLAG
, CLOSE_DATE
, OLD_CLOSE_DATE
, CHANGE_CLOSE_DATE_FLAG
, CUSTOMER_PRODUCT_ID
, OLD_CUSTOMER_PRODUCT_ID
, CHANGE_CUSTOMER_PRODUCT_FLAG
, AUDIT_FIELD
, OBJECT_VERSION_NUMBER
, PLATFORM_ID
, OLD_PLATFORM_ID
, CHANGE_PLATFORM_ID_FLAG
, PLATFORM_VERSION_ID
, OLD_PLATFORM_VERSION_ID
, CHANGE_PLAT_VER_ID_FLAG
, CP_COMPONENT_ID
, OLD_CP_COMPONENT_ID
, CHANGE_CP_COMPONENT_ID_FLAG
, CP_COMPONENT_VERSION_ID
, OLD_CP_COMPONENT_VERSION_ID
, CHANGE_CP_COMP_VER_ID_FLAG
, CP_SUBCOMPONENT_ID
, OLD_CP_SUBCOMPONENT_ID
, CHANGE_CP_SUBCOMPONENT_ID_FLAG
, CP_SUBCOMPONENT_VERSION_ID
, OLD_CP_SUBCOMPONENT_VERSION_ID
, CHANGE_CP_SUBCOMP_VER_ID_FLAG
, LANGUAGE_ID
, OLD_LANGUAGE_ID
, CHANGE_LANGUAGE_ID_FLAG
, TERRITORY_ID
, OLD_TERRITORY_ID
, CHANGE_TERRITORY_ID_FLAG
, CP_REVISION_ID
, OLD_CP_REVISION_ID
, CHANGE_CP_REVISION_ID_FLAG
, INV_ITEM_REVISION
, OLD_INV_ITEM_REVISION
, CHANGE_INV_ITEM_REVISION
, INV_COMPONENT_ID
, OLD_INV_COMPONENT_ID
, CHANGE_INV_COMPONENT_ID
, INV_COMPONENT_VERSION
, OLD_INV_COMPONENT_VERSION
, CHANGE_INV_COMPONENT_VERSION
, INV_SUBCOMPONENT_ID
, OLD_INV_SUBCOMPONENT_ID
, CHANGE_INV_SUBCOMPONENT_ID
, INV_SUBCOMPONENT_VERSION
, OLD_INV_SUBCOMPONENT_VERSION
, CHANGE_INV_SUBCOMP_VERSION
, RESOURCE_TYPE
, OLD_RESOURCE_TYPE
, CHANGE_RESOURCE_TYPE_FLAG
, SECURITY_GROUP_ID
, UPGRADED_STATUS_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OLD_GROUP_TYPE
, GROUP_TYPE
, CHANGE_GROUP_TYPE_FLAG
, OLD_OWNER_ASSIGNED_TIME
, OWNER_ASSIGNED_TIME
, CHANGE_ASSIGNED_TIME_FLAG
, INV_PLATFORM_ORG_ID
, OLD_INV_PLATFORM_ORG_ID
, CHANGE_PLATFORM_ORG_ID_FLAG
, COMPONENT_VERSION
, OLD_COMPONENT_VERSION
, CHANGE_COMP_VER_FLAG
, SUBCOMPONENT_VERSION
, OLD_SUBCOMPONENT_VERSION
, CHANGE_SUBCOMP_VER_FLAG
, PRODUCT_REVISION
, OLD_PRODUCT_REVISION
, CHANGE_PRODUCT_REVISION_FLAG
, STATUS_FLAG
, OLD_STATUS_FLAG
, CHANGE_STATUS_FLAG
, INVENTORY_ITEM_ID
, OLD_INVENTORY_ITEM_ID
, CHANGE_INVENTORY_ITEM_FLAG
, INV_ORGANIZATION_ID
, OLD_INV_ORGANIZATION_ID
, CHANGE_INV_ORGANIZATION_FLAG
, PRIMARY_CONTACT_ID
, OLD_PRIMARY_CONTACT_ID
, CHANGE_PRIMARY_CONTACT_FLAG
, UPGRADE_FLAG_FOR_CREATE
, OLD_INCIDENT_NUMBER
, INCIDENT_NUMBER
, OLD_CUSTOMER_ID
, CUSTOMER_ID
, OLD_BILL_TO_SITE_USE_ID
, BILL_TO_SITE_USE_ID
, OLD_EMPLOYEE_ID
, EMPLOYEE_ID
, OLD_SHIP_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID
, OLD_PROBLEM_CODE
, PROBLEM_CODE
, OLD_ACTUAL_RESOLUTION_DATE
, ACTUAL_RESOLUTION_DATE
, OLD_INSTALL_SITE_USE_ID
, INSTALL_SITE_USE_ID
, OLD_CURRENT_SERIAL_NUMBER
, CURRENT_SERIAL_NUMBER
, OLD_SYSTEM_ID
, SYSTEM_ID
, OLD_INCIDENT_ATTRIBUTE_1
, INCIDENT_ATTRIBUTE_1
, OLD_INCIDENT_ATTRIBUTE_2
, INCIDENT_ATTRIBUTE_2
, OLD_INCIDENT_ATTRIBUTE_3
, INCIDENT_ATTRIBUTE_3
, OLD_INCIDENT_ATTRIBUTE_4
, INCIDENT_ATTRIBUTE_4
, OLD_INCIDENT_ATTRIBUTE_5
, INCIDENT_ATTRIBUTE_5
, OLD_INCIDENT_ATTRIBUTE_6
, INCIDENT_ATTRIBUTE_6
, OLD_INCIDENT_ATTRIBUTE_7
, INCIDENT_ATTRIBUTE_7
, OLD_INCIDENT_ATTRIBUTE_8
, INCIDENT_ATTRIBUTE_8
, OLD_INCIDENT_ATTRIBUTE_9
, INCIDENT_ATTRIBUTE_9
, OLD_INCIDENT_ATTRIBUTE_10
, INCIDENT_ATTRIBUTE_10
, OLD_INCIDENT_ATTRIBUTE_11
, INCIDENT_ATTRIBUTE_11
, OLD_INCIDENT_ATTRIBUTE_12
, INCIDENT_ATTRIBUTE_12
, OLD_INCIDENT_ATTRIBUTE_13
, INCIDENT_ATTRIBUTE_13
, OLD_INCIDENT_ATTRIBUTE_14
, INCIDENT_ATTRIBUTE_14
, OLD_INCIDENT_ATTRIBUTE_15
, INCIDENT_ATTRIBUTE_15
, OLD_INCIDENT_CONTEXT
, INCIDENT_CONTEXT
, OLD_RESOLUTION_CODE
, RESOLUTION_CODE
, OLD_ORIGINAL_ORDER_NUMBER
, ORIGINAL_ORDER_NUMBER
, OLD_ORG_ID
, ORG_ID
, OLD_PURCHASE_ORDER_NUMBER
, PURCHASE_ORDER_NUMBER
, OLD_PUBLISH_FLAG
, PUBLISH_FLAG
, OLD_QA_COLLECTION_ID
, QA_COLLECTION_ID
, OLD_CONTRACT_ID
, CONTRACT_ID
, OLD_CONTRACT_NUMBER
, CONTRACT_NUMBER
, OLD_CONTRACT_SERVICE_ID
, CONTRACT_SERVICE_ID
, OLD_TIME_ZONE_ID
, TIME_ZONE_ID
, OLD_ACCOUNT_ID
, ACCOUNT_ID
, OLD_TIME_DIFFERENCE
, TIME_DIFFERENCE
, OLD_CUSTOMER_PO_NUMBER
, CUSTOMER_PO_NUMBER
, OLD_CUSTOMER_TICKET_NUMBER
, CUSTOMER_TICKET_NUMBER
, OLD_CUSTOMER_SITE_ID
, CUSTOMER_SITE_ID
, OLD_CALLER_TYPE
, CALLER_TYPE
, OLD_INC_OBJECT_VERSION_NUMBER
, INC_OBJECT_VERSION_NUMBER
, OLD_SECURITY_GROUP_ID
, OLD_ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_REFERENCE
, OLD_ORIG_SYSTEM_REFERENCE_ID
, ORIG_SYSTEM_REFERENCE_ID
, OLD_INC_REQUEST_ID
, INC_REQUEST_ID
, OLD_INC_PROGRAM_APPLICATION_ID
, INC_PROGRAM_APPLICATION_ID
, OLD_INC_PROGRAM_ID
, INC_PROGRAM_ID
, OLD_INC_PROGRAM_UPDATE_DATE
, INC_PROGRAM_UPDATE_DATE
, OLD_PROJECT_NUMBER
, PROJECT_NUMBER
, OLD_PLATFORM_VERSION
, PLATFORM_VERSION
, OLD_DB_VERSION
, DB_VERSION
, OLD_CUST_PREF_LANG_ID
, CUST_PREF_LANG_ID
, OLD_TIER
, TIER
, OLD_TIER_VERSION
, TIER_VERSION
, OLD_CATEGORY_ID
, CATEGORY_ID
, OLD_OPERATING_SYSTEM
, OPERATING_SYSTEM
, OLD_OPERATING_SYSTEM_VERSION
, OPERATING_SYSTEM_VERSION
, OLD_DATABASE
, DATABASE
, OLD_GROUP_TERRITORY_ID
, GROUP_TERRITORY_ID
, OLD_COMM_PREF_CODE
, COMM_PREF_CODE
, OLD_LAST_UPDATE_CHANNEL
, LAST_UPDATE_CHANNEL
, OLD_CUST_PREF_LANG_CODE
, CUST_PREF_LANG_CODE
, OLD_ERROR_CODE
, ERROR_CODE
, OLD_CATEGORY_SET_ID
, CATEGORY_SET_ID
, OLD_EXTERNAL_REFERENCE
, EXTERNAL_REFERENCE
, OLD_INCIDENT_OCCURRED_DATE
, INCIDENT_OCCURRED_DATE
, OLD_INCIDENT_RESOLVED_DATE
, INCIDENT_RESOLVED_DATE
, OLD_INC_RESPONDED_BY_DATE
, INC_RESPONDED_BY_DATE
, OLD_INCIDENT_LOCATION_ID
, INCIDENT_LOCATION_ID
, OLD_INCIDENT_ADDRESS
, INCIDENT_ADDRESS
, OLD_INCIDENT_CITY
, INCIDENT_CITY
, OLD_INCIDENT_STATE
, INCIDENT_STATE
, OLD_INCIDENT_COUNTRY
, INCIDENT_COUNTRY
, OLD_INCIDENT_PROVINCE
, INCIDENT_PROVINCE
, OLD_INCIDENT_POSTAL_CODE
, INCIDENT_POSTAL_CODE
, OLD_INCIDENT_COUNTY
, INCIDENT_COUNTY
, OLD_SR_CREATION_CHANNEL
, SR_CREATION_CHANNEL
, OLD_DEF_DEFECT_ID
, DEF_DEFECT_ID
, OLD_DEF_DEFECT_ID2
, DEF_DEFECT_ID2
, OLD_CREDIT_CARD_NUMBER
, CREDIT_CARD_NUMBER
, OLD_CREDIT_CARD_TYPE_CODE
, CREDIT_CARD_TYPE_CODE
, OLD_CREDIT_CARD_EXPIRATION_DT
, CREDIT_CARD_EXPIRATION_DT
, OLD_CREDIT_CARD_HOLDER_FNAME
, CREDIT_CARD_HOLDER_FNAME
, OLD_CREDIT_CARD_HOLDER_MNAME
, CREDIT_CARD_HOLDER_MNAME
, OLD_CREDIT_CARD_HOLDER_LNAME
, CREDIT_CARD_HOLDER_LNAME
, OLD_CREDIT_CARD_ID
, CREDIT_CARD_ID
, OLD_EXTERNAL_ATTRIBUTE_1
, EXTERNAL_ATTRIBUTE_1
, OLD_EXTERNAL_ATTRIBUTE_2
, EXTERNAL_ATTRIBUTE_2
, OLD_EXTERNAL_ATTRIBUTE_3
, EXTERNAL_ATTRIBUTE_3
, OLD_EXTERNAL_ATTRIBUTE_4
, EXTERNAL_ATTRIBUTE_4
, OLD_EXTERNAL_ATTRIBUTE_5
, EXTERNAL_ATTRIBUTE_5
, OLD_EXTERNAL_ATTRIBUTE_6
, EXTERNAL_ATTRIBUTE_6
, OLD_EXTERNAL_ATTRIBUTE_7
, EXTERNAL_ATTRIBUTE_7
, OLD_EXTERNAL_ATTRIBUTE_8
, EXTERNAL_ATTRIBUTE_8
, OLD_EXTERNAL_ATTRIBUTE_9
, EXTERNAL_ATTRIBUTE_9
, OLD_EXTERNAL_ATTRIBUTE_10
, EXTERNAL_ATTRIBUTE_10
, OLD_EXTERNAL_ATTRIBUTE_11
, EXTERNAL_ATTRIBUTE_11
, OLD_EXTERNAL_ATTRIBUTE_12
, EXTERNAL_ATTRIBUTE_12
, OLD_EXTERNAL_ATTRIBUTE_13
, EXTERNAL_ATTRIBUTE_13
, OLD_EXTERNAL_ATTRIBUTE_14
, EXTERNAL_ATTRIBUTE_14
, OLD_EXTERNAL_ATTRIBUTE_15
, EXTERNAL_ATTRIBUTE_15
, OLD_EXTERNAL_CONTEXT
, EXTERNAL_CONTEXT
, OLD_LAST_UPDATE_PROGRAM_CODE
, LAST_UPDATE_PROGRAM_CODE
, OLD_CREATION_PROGRAM_CODE
, CREATION_PROGRAM_CODE
, OLD_COVERAGE_TYPE
, COVERAGE_TYPE
, OLD_BILL_TO_ACCOUNT_ID
, BILL_TO_ACCOUNT_ID
, OLD_SHIP_TO_ACCOUNT_ID
, SHIP_TO_ACCOUNT_ID
, OLD_CUSTOMER_EMAIL_ID
, CUSTOMER_EMAIL_ID
, OLD_CUSTOMER_PHONE_ID
, CUSTOMER_PHONE_ID
, OLD_BILL_TO_PARTY_ID
, BILL_TO_PARTY_ID
, OLD_SHIP_TO_PARTY_ID
, SHIP_TO_PARTY_ID
, OLD_BILL_TO_SITE_ID
, BILL_TO_SITE_ID
, OLD_SHIP_TO_SITE_ID
, SHIP_TO_SITE_ID
, OLD_PROGRAM_LOGIN_ID
, PROGRAM_LOGIN_ID
, OLD_INCIDENT_POINT_OF_INTEREST
, INCIDENT_POINT_OF_INTEREST
, OLD_INCIDENT_CROSS_STREET
, INCIDENT_CROSS_STREET
, OLD_INCIDENT_DIRECTION_QUALIF
, INCIDENT_DIRECTION_QUALIF
, OLD_INCIDENT_DISTANCE_QUALIF
, INCIDENT_DISTANCE_QUALIF
, OLD_INCIDENT_DISTANCE_QUAL_UOM
, INCIDENT_DISTANCE_QUAL_UOM
, OLD_INCIDENT_ADDRESS2
, INCIDENT_ADDRESS2
, OLD_INCIDENT_ADDRESS3
, INCIDENT_ADDRESS3
, OLD_INCIDENT_ADDRESS4
, INCIDENT_ADDRESS4
, OLD_INCIDENT_ADDRESS_STYLE
, INCIDENT_ADDRESS_STYLE
, OLD_INCIDENT_ADDR_LNS_PHONETIC
, INCIDENT_ADDR_LNS_PHONETIC
, OLD_INCIDENT_PO_BOX_NUMBER
, INCIDENT_PO_BOX_NUMBER
, OLD_INCIDENT_HOUSE_NUMBER
, INCIDENT_HOUSE_NUMBER
, OLD_INCIDENT_STREET_SUFFIX
, INCIDENT_STREET_SUFFIX
, OLD_INCIDENT_STREET
, INCIDENT_STREET
, OLD_INCIDENT_STREET_NUMBER
, INCIDENT_STREET_NUMBER
, OLD_INCIDENT_FLOOR
, INCIDENT_FLOOR
, OLD_INCIDENT_SUITE
, INCIDENT_SUITE
, OLD_INCIDENT_POSTAL_PLUS4_CODE
, INCIDENT_POSTAL_PLUS4_CODE
, OLD_INCIDENT_POSITION
, INCIDENT_POSITION
, OLD_INCIDENT_LOC_DIRECTIONS
, INCIDENT_LOC_DIRECTIONS
, OLD_INCIDENT_LOC_DESCRIPTION
, INCIDENT_LOC_DESCRIPTION
, OLD_INSTALL_SITE_ID
, INSTALL_SITE_ID
, INCIDENT_LAST_MODIFIED_DATE
, UPDATED_ENTITY_CODE
, UPDATED_ENTITY_ID
, ENTITY_ACTIVITY_CODE
, OLD_OWNING_DEPARTMENT_ID
, OWNING_DEPARTMENT_ID
, OLD_ITEM_SERIAL_NUMBER
, ITEM_SERIAL_NUMBER
, OLD_INCIDENT_LOCATION_TYPE
, INCIDENT_LOCATION_TYPE
, OLD_UNASSIGNED_INDICATOR
, UNASSIGNED_INDICATOR
, OLD_OWNER_ASSIGNED_FLAG
, OWNER_ASSIGNED_FLAG
, OLD_MAINT_ORGANIZATION_ID
, MAINT_ORGANIZATION_ID
, PROJECT_ID
, OLD_PROJECT_ID
, PROJECT_TASK_ID
, OLD_PROJECT_TASK_ID
, OLD_PRICE_LIST_HEADER_ID
, PRICE_LIST_HEADER_ID
, OLD_EXPENDITURE_ORG_ID
, EXPENDITURE_ORG_ID
, CHANGE_SLA_DATE_1_FLAG
, OLD_SLA_DATE_1
, SLA_DATE_1
, CHANGE_SLA_DATE_2_FLAG
, OLD_SLA_DATE_2
, SLA_DATE_2
, CHANGE_SLA_DATE_3_FLAG
, OLD_SLA_DATE_3
, SLA_DATE_3
, CHANGE_SLA_DATE_4_FLAG
, OLD_SLA_DATE_4
, SLA_DATE_4
, CHANGE_SLA_DATE_5_FLAG
, OLD_SLA_DATE_5
, SLA_DATE_5
, CHANGE_SLA_DATE_6_FLAG
, OLD_SLA_DATE_6
, SLA_DATE_6
, CHANGE_SLA_DURATION_1_FLAG
, OLD_SLA_DURATION_1
, SLA_DURATION_1
, CHANGE_SLA_DURATION_2_FLAG
, OLD_SLA_DURATION_2
, SLA_DURATION_2
FROM CS.CS_INCIDENTS_AUDIT_B#;
|
|
|