eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: CS.CS_MASS_NOTIFICATION_TXNS_TEM#

Source

View Text - Preformatted


select MASS_NOTIFICATION_TXN_TEMP_ID MASS_NOTIFICATION_TXN_TEMP_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, TRANSACTION_CODE TRANSACTION_CODE, UPDATE_CRITERIA_SET UPDATE_CRITERIA_SET, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, CUSTOMER_ID CUSTOMER_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CP_SERIAL_NUMBER CP_SERIAL_NUMBER, AVAILABLE_FLAG AVAILABLE_FLAG, ORDERED_FLAG ORDERED_FLAG, NOTIFIED_FLAG NOTIFIED_FLAG, EXCEPTION_FLAG EXCEPTION_FLAG, EXCEPTION_REASON_CODE EXCEPTION_REASON_CODE, ORDER_REQUEST_ID ORDER_REQUEST_ID, LETTER_REQUEST_ID LETTER_REQUEST_ID, SYSTEM_ID SYSTEM_ID, CP_REVISION CP_REVISION, SERVICE_AGREEMENT_ID SERVICE_AGREEMENT_ID, PRODUCT_AGREEMENT_ID PRODUCT_AGREEMENT_ID, ORDER_TYPE_ID ORDER_TYPE_ID, UPDATE_MODEL_ID UPDATE_MODEL_ID, UPDATE_INVENTORY_ITEM_ID UPDATE_INVENTORY_ITEM_ID, UPDATE_MANUFACTURING_ORG_ID UPDATE_MANUFACTURING_ORG_ID, CP_TRANSACTION_TYPE_ID CP_TRANSACTION_TYPE_ID, CP_ATTRIBUTE1 CP_ATTRIBUTE1, CP_ATTRIBUTE2 CP_ATTRIBUTE2, CP_ATTRIBUTE3 CP_ATTRIBUTE3, CP_ATTRIBUTE4 CP_ATTRIBUTE4, CP_ATTRIBUTE5 CP_ATTRIBUTE5, CP_ATTRIBUTE6 CP_ATTRIBUTE6, CP_ATTRIBUTE7 CP_ATTRIBUTE7, CP_ATTRIBUTE8 CP_ATTRIBUTE8, CP_ATTRIBUTE9 CP_ATTRIBUTE9, CP_ATTRIBUTE10 CP_ATTRIBUTE10, CP_ATTRIBUTE11 CP_ATTRIBUTE11, CP_ATTRIBUTE12 CP_ATTRIBUTE12, CP_ATTRIBUTE13 CP_ATTRIBUTE13, CP_ATTRIBUTE14 CP_ATTRIBUTE14, CP_ATTRIBUTE15 CP_ATTRIBUTE15, CP_CONTEXT CP_CONTEXT, SELECTED_FLAG SELECTED_FLAG from "CS"."CS_MASS_NOTIFICATION_TXNS_TEMP"

View Text - HTML Formatted

SELECT MASS_NOTIFICATION_TXN_TEMP_ID MASS_NOTIFICATION_TXN_TEMP_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, TRANSACTION_CODE TRANSACTION_CODE
, UPDATE_CRITERIA_SET UPDATE_CRITERIA_SET
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, CUSTOMER_ID CUSTOMER_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CP_SERIAL_NUMBER CP_SERIAL_NUMBER
, AVAILABLE_FLAG AVAILABLE_FLAG
, ORDERED_FLAG ORDERED_FLAG
, NOTIFIED_FLAG NOTIFIED_FLAG
, EXCEPTION_FLAG EXCEPTION_FLAG
, EXCEPTION_REASON_CODE EXCEPTION_REASON_CODE
, ORDER_REQUEST_ID ORDER_REQUEST_ID
, LETTER_REQUEST_ID LETTER_REQUEST_ID
, SYSTEM_ID SYSTEM_ID
, CP_REVISION CP_REVISION
, SERVICE_AGREEMENT_ID SERVICE_AGREEMENT_ID
, PRODUCT_AGREEMENT_ID PRODUCT_AGREEMENT_ID
, ORDER_TYPE_ID ORDER_TYPE_ID
, UPDATE_MODEL_ID UPDATE_MODEL_ID
, UPDATE_INVENTORY_ITEM_ID UPDATE_INVENTORY_ITEM_ID
, UPDATE_MANUFACTURING_ORG_ID UPDATE_MANUFACTURING_ORG_ID
, CP_TRANSACTION_TYPE_ID CP_TRANSACTION_TYPE_ID
, CP_ATTRIBUTE1 CP_ATTRIBUTE1
, CP_ATTRIBUTE2 CP_ATTRIBUTE2
, CP_ATTRIBUTE3 CP_ATTRIBUTE3
, CP_ATTRIBUTE4 CP_ATTRIBUTE4
, CP_ATTRIBUTE5 CP_ATTRIBUTE5
, CP_ATTRIBUTE6 CP_ATTRIBUTE6
, CP_ATTRIBUTE7 CP_ATTRIBUTE7
, CP_ATTRIBUTE8 CP_ATTRIBUTE8
, CP_ATTRIBUTE9 CP_ATTRIBUTE9
, CP_ATTRIBUTE10 CP_ATTRIBUTE10
, CP_ATTRIBUTE11 CP_ATTRIBUTE11
, CP_ATTRIBUTE12 CP_ATTRIBUTE12
, CP_ATTRIBUTE13 CP_ATTRIBUTE13
, CP_ATTRIBUTE14 CP_ATTRIBUTE14
, CP_ATTRIBUTE15 CP_ATTRIBUTE15
, CP_CONTEXT CP_CONTEXT
, SELECTED_FLAG SELECTED_FLAG
FROM "CS"."CS_MASS_NOTIFICATION_TXNS_TEMP"