VIEW: CS.CS_CP_AUDIT#

Source

View Text - Preformatted

select CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CUSTOMER_CHANGED_FLAG CUSTOMER_CHANGED_FLAG, OLD_CUSTOMER_ID OLD_CUSTOMER_ID, CURRENT_CUSTOMER_ID CURRENT_CUSTOMER_ID, SYSTEM_CHANGED_FLAG SYSTEM_CHANGED_FLAG, OLD_SYSTEM_ID OLD_SYSTEM_ID, CURRENT_SYSTEM_ID CURRENT_SYSTEM_ID, PRODUCT_AGREEMENT_CHANGED_FLAG PRODUCT_AGREEMENT_CHANGED_FLAG, OLD_PRODUCT_AGREEMENT_ID OLD_PRODUCT_AGREEMENT_ID, CURRENT_PRODUCT_AGREEMENT_ID CURRENT_PRODUCT_AGREEMENT_ID, SERVICE_AGREEMENT_CHANGED_FLAG SERVICE_AGREEMENT_CHANGED_FLAG, OLD_SERVICE_AGREEMENT_ID OLD_SERVICE_AGREEMENT_ID, CURRENT_SERVICE_AGREEMENT_ID CURRENT_SERVICE_AGREEMENT_ID, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CONTEXT CONTEXT, COMMENTS COMMENTS, CP_STATUS_CHANGED_FLAG CP_STATUS_CHANGED_FLAG, OLD_CP_STATUS_ID OLD_CP_STATUS_ID, CURRENT_CP_STATUS_ID CURRENT_CP_STATUS_ID, TYPE_CODE_CHANGED_FLAG TYPE_CODE_CHANGED_FLAG, OLD_TYPE_CODE OLD_TYPE_CODE, CURRENT_TYPE_CODE CURRENT_TYPE_CODE, SPLIT_CP_ID SPLIT_CP_ID, CP_QUANTITY_CHANGED_FLAG CP_QUANTITY_CHANGED_FLAG, OLD_CP_QUANTITY OLD_CP_QUANTITY, CURRENT_CP_QUANTITY CURRENT_CP_QUANTITY, CP_SPLIT_REASON_CODE CP_SPLIT_REASON_CODE, CP_AUDIT_ID CP_AUDIT_ID, OLD_INVENTORY_ITEM_ID OLD_INVENTORY_ITEM_ID, CURRENT_INVENTORY_ITEM_ID CURRENT_INVENTORY_ITEM_ID, OLD_ORIGINAL_ORDER_LINE_ID OLD_ORIGINAL_ORDER_LINE_ID, CURRENT_ORIGINAL_ORDER_LINE_ID CURRENT_ORIGINAL_ORDER_LINE_ID, OLD_LOT_NUMBER OLD_LOT_NUMBER, CURRENT_LOT_NUMBER CURRENT_LOT_NUMBER, OLD_SERIAL_NUMBER OLD_SERIAL_NUMBER, CURRENT_PROJECT_ID CURRENT_PROJECT_ID, OLD_PROJECT_ID OLD_PROJECT_ID, CURRENT_TASK_ID CURRENT_TASK_ID, OLD_TASK_ID OLD_TASK_ID, CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER, OLD_INSTALLATION_DATE OLD_INSTALLATION_DATE, CURRENT_INSTALLATION_DATE CURRENT_INSTALLATION_DATE, OLD_SHIP_TO_SITE_USE_ID OLD_SHIP_TO_SITE_USE_ID, CURRENT_SHIP_TO_SITE_USE_ID CURRENT_SHIP_TO_SITE_USE_ID, OLD_BILL_TO_SITE_USE_ID OLD_BILL_TO_SITE_USE_ID, CURRENT_BILL_TO_SITE_USE_ID CURRENT_BILL_TO_SITE_USE_ID, OLD_INSTALL_SITE_USE_ID OLD_INSTALL_SITE_USE_ID, CURRENT_INSTALL_SITE_USE_ID CURRENT_INSTALL_SITE_USE_ID, OLD_UNIT_OF_MEASURE_CODE OLD_UNIT_OF_MEASURE_CODE, CURRENT_UNIT_OF_MEASURE_CODE CURRENT_UNIT_OF_MEASURE_CODE, OLD_SHIPPED_DATE OLD_SHIPPED_DATE, CURRENT_SHIPPED_DATE CURRENT_SHIPPED_DATE, OLD_RETURN_BY_DATE OLD_RETURN_BY_DATE, CURRENT_RETURN_BY_DATE CURRENT_RETURN_BY_DATE, OLD_ACTUAL_RETURNED_DATE OLD_ACTUAL_RETURNED_DATE, CURRENT_ACTUAL_RETURNED_DATE CURRENT_ACTUAL_RETURNED_DATE, OLD_RMA_LINE_ID OLD_RMA_LINE_ID, CURRENT_RMA_LINE_ID CURRENT_RMA_LINE_ID, OLD_CONFIG_START_DATE OLD_CONFIG_START_DATE, CURRENT_CONFIG_START_DATE CURRENT_CONFIG_START_DATE, OLD_CONFIG_END_DATE OLD_CONFIG_END_DATE, CURRENT_CONFIG_END_DATE CURRENT_CONFIG_END_DATE, OLD_CONFIG_TYPE OLD_CONFIG_TYPE, CURRENT_CONFIG_TYPE CURRENT_CONFIG_TYPE, OLD_CONFIG_PARENT_ID OLD_CONFIG_PARENT_ID, CURRENT_CONFIG_PARENT_ID CURRENT_CONFIG_PARENT_ID, OLD_PLATFORM_VERSION_ID OLD_PLATFORM_VERSION_ID, CURRENT_PLATFORM_VERSION_ID CURRENT_PLATFORM_VERSION_ID, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE, CURRENT_START_DATE_ACTIVE CURRENT_START_DATE_ACTIVE, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE, CURRENT_END_DATE_ACTIVE CURRENT_END_DATE_ACTIVE, OLD_MERCHANT_VIEW_FLAG OLD_MERCHANT_VIEW_FLAG, CURRENT_MERCHANT_VIEW_FLAG CURRENT_MERCHANT_VIEW_FLAG, OLD_CUSTOMER_VIEW_FLAG OLD_CUSTOMER_VIEW_FLAG, CURRENT_CUSTOMER_VIEW_FLAG CURRENT_CUSTOMER_VIEW_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, UPGRADED_STATUS_FLAG UPGRADED_STATUS_FLAG, VALID_FOR_CSI_MIGRATION VALID_FOR_CSI_MIGRATION, MIGRATED_STATUS_FLAG MIGRATED_STATUS_FLAG, OLD_BILL_TO_SITE_USE OLD_BILL_TO_SITE_USE, OLD_SHIP_TO_SITE_USE OLD_SHIP_TO_SITE_USE, CURRENT_BILL_TO_SITE_USE CURRENT_BILL_TO_SITE_USE, CURRENT_SHIP_TO_SITE_USE CURRENT_SHIP_TO_SITE_USE from "CS"."CS_CP_AUDIT"

View Text - HTML Formatted

SELECT CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CUSTOMER_CHANGED_FLAG CUSTOMER_CHANGED_FLAG
, OLD_CUSTOMER_ID OLD_CUSTOMER_ID
, CURRENT_CUSTOMER_ID CURRENT_CUSTOMER_ID
, SYSTEM_CHANGED_FLAG SYSTEM_CHANGED_FLAG
, OLD_SYSTEM_ID OLD_SYSTEM_ID
, CURRENT_SYSTEM_ID CURRENT_SYSTEM_ID
, PRODUCT_AGREEMENT_CHANGED_FLAG PRODUCT_AGREEMENT_CHANGED_FLAG
, OLD_PRODUCT_AGREEMENT_ID OLD_PRODUCT_AGREEMENT_ID
, CURRENT_PRODUCT_AGREEMENT_ID CURRENT_PRODUCT_AGREEMENT_ID
, SERVICE_AGREEMENT_CHANGED_FLAG SERVICE_AGREEMENT_CHANGED_FLAG
, OLD_SERVICE_AGREEMENT_ID OLD_SERVICE_AGREEMENT_ID
, CURRENT_SERVICE_AGREEMENT_ID CURRENT_SERVICE_AGREEMENT_ID
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CONTEXT CONTEXT
, COMMENTS COMMENTS
, CP_STATUS_CHANGED_FLAG CP_STATUS_CHANGED_FLAG
, OLD_CP_STATUS_ID OLD_CP_STATUS_ID
, CURRENT_CP_STATUS_ID CURRENT_CP_STATUS_ID
, TYPE_CODE_CHANGED_FLAG TYPE_CODE_CHANGED_FLAG
, OLD_TYPE_CODE OLD_TYPE_CODE
, CURRENT_TYPE_CODE CURRENT_TYPE_CODE
, SPLIT_CP_ID SPLIT_CP_ID
, CP_QUANTITY_CHANGED_FLAG CP_QUANTITY_CHANGED_FLAG
, OLD_CP_QUANTITY OLD_CP_QUANTITY
, CURRENT_CP_QUANTITY CURRENT_CP_QUANTITY
, CP_SPLIT_REASON_CODE CP_SPLIT_REASON_CODE
, CP_AUDIT_ID CP_AUDIT_ID
, OLD_INVENTORY_ITEM_ID OLD_INVENTORY_ITEM_ID
, CURRENT_INVENTORY_ITEM_ID CURRENT_INVENTORY_ITEM_ID
, OLD_ORIGINAL_ORDER_LINE_ID OLD_ORIGINAL_ORDER_LINE_ID
, CURRENT_ORIGINAL_ORDER_LINE_ID CURRENT_ORIGINAL_ORDER_LINE_ID
, OLD_LOT_NUMBER OLD_LOT_NUMBER
, CURRENT_LOT_NUMBER CURRENT_LOT_NUMBER
, OLD_SERIAL_NUMBER OLD_SERIAL_NUMBER
, CURRENT_PROJECT_ID CURRENT_PROJECT_ID
, OLD_PROJECT_ID OLD_PROJECT_ID
, CURRENT_TASK_ID CURRENT_TASK_ID
, OLD_TASK_ID OLD_TASK_ID
, CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, OLD_INSTALLATION_DATE OLD_INSTALLATION_DATE
, CURRENT_INSTALLATION_DATE CURRENT_INSTALLATION_DATE
, OLD_SHIP_TO_SITE_USE_ID OLD_SHIP_TO_SITE_USE_ID
, CURRENT_SHIP_TO_SITE_USE_ID CURRENT_SHIP_TO_SITE_USE_ID
, OLD_BILL_TO_SITE_USE_ID OLD_BILL_TO_SITE_USE_ID
, CURRENT_BILL_TO_SITE_USE_ID CURRENT_BILL_TO_SITE_USE_ID
, OLD_INSTALL_SITE_USE_ID OLD_INSTALL_SITE_USE_ID
, CURRENT_INSTALL_SITE_USE_ID CURRENT_INSTALL_SITE_USE_ID
, OLD_UNIT_OF_MEASURE_CODE OLD_UNIT_OF_MEASURE_CODE
, CURRENT_UNIT_OF_MEASURE_CODE CURRENT_UNIT_OF_MEASURE_CODE
, OLD_SHIPPED_DATE OLD_SHIPPED_DATE
, CURRENT_SHIPPED_DATE CURRENT_SHIPPED_DATE
, OLD_RETURN_BY_DATE OLD_RETURN_BY_DATE
, CURRENT_RETURN_BY_DATE CURRENT_RETURN_BY_DATE
, OLD_ACTUAL_RETURNED_DATE OLD_ACTUAL_RETURNED_DATE
, CURRENT_ACTUAL_RETURNED_DATE CURRENT_ACTUAL_RETURNED_DATE
, OLD_RMA_LINE_ID OLD_RMA_LINE_ID
, CURRENT_RMA_LINE_ID CURRENT_RMA_LINE_ID
, OLD_CONFIG_START_DATE OLD_CONFIG_START_DATE
, CURRENT_CONFIG_START_DATE CURRENT_CONFIG_START_DATE
, OLD_CONFIG_END_DATE OLD_CONFIG_END_DATE
, CURRENT_CONFIG_END_DATE CURRENT_CONFIG_END_DATE
, OLD_CONFIG_TYPE OLD_CONFIG_TYPE
, CURRENT_CONFIG_TYPE CURRENT_CONFIG_TYPE
, OLD_CONFIG_PARENT_ID OLD_CONFIG_PARENT_ID
, CURRENT_CONFIG_PARENT_ID CURRENT_CONFIG_PARENT_ID
, OLD_PLATFORM_VERSION_ID OLD_PLATFORM_VERSION_ID
, CURRENT_PLATFORM_VERSION_ID CURRENT_PLATFORM_VERSION_ID
, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE
, CURRENT_START_DATE_ACTIVE CURRENT_START_DATE_ACTIVE
, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE
, CURRENT_END_DATE_ACTIVE CURRENT_END_DATE_ACTIVE
, OLD_MERCHANT_VIEW_FLAG OLD_MERCHANT_VIEW_FLAG
, CURRENT_MERCHANT_VIEW_FLAG CURRENT_MERCHANT_VIEW_FLAG
, OLD_CUSTOMER_VIEW_FLAG OLD_CUSTOMER_VIEW_FLAG
, CURRENT_CUSTOMER_VIEW_FLAG CURRENT_CUSTOMER_VIEW_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, UPGRADED_STATUS_FLAG UPGRADED_STATUS_FLAG
, VALID_FOR_CSI_MIGRATION VALID_FOR_CSI_MIGRATION
, MIGRATED_STATUS_FLAG MIGRATED_STATUS_FLAG
, OLD_BILL_TO_SITE_USE OLD_BILL_TO_SITE_USE
, OLD_SHIP_TO_SITE_USE OLD_SHIP_TO_SITE_USE
, CURRENT_BILL_TO_SITE_USE CURRENT_BILL_TO_SITE_USE
, CURRENT_SHIP_TO_SITE_USE CURRENT_SHIP_TO_SITE_USE
FROM "CS"."CS_CP_AUDIT"