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.

VIEW: CS.CS_MASS_SERVICE_TXNS_TEMP#

Source

View Text - Preformatted


select MASS_SERVICE_TXN_TEMP_ID MASS_SERVICE_TXN_TEMP_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, TRANSACTION_CODE TRANSACTION_CODE, RENEWAL_CRITERIA_SET RENEWAL_CRITERIA_SET, CP_SERVICE_ID CP_SERVICE_ID, 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, RENEWAL_DURATION_QUANTITY RENEWAL_DURATION_QUANTITY, RENEWAL_UNIT_OF_MEASURE_CODE RENEWAL_UNIT_OF_MEASURE_CODE, RENEWAL_THROUGH_DATE RENEWAL_THROUGH_DATE, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE, TRANSACTION_COMMENTS TRANSACTION_COMMENTS, ORDER_TYPE_ID ORDER_TYPE_ID, CUSTOMER_ID CUSTOMER_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CP_SERIAL_NUMBER CP_SERIAL_NUMBER, CP_REVISION_ID CP_REVISION_ID, SYSTEM_ID SYSTEM_ID, PRODUCT_AGREEMENT_ID PRODUCT_AGREEMENT_ID, SERVICE_AGREEMENT_ID SERVICE_AGREEMENT_ID, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID, SERVICE_MANUFACTURING_ORG_ID SERVICE_MANUFACTURING_ORG_ID, SERVICE_START_DATE SERVICE_START_DATE, SERVICE_END_DATE SERVICE_END_DATE, SELECTED_FLAG SELECTED_FLAG from "CS"."CS_MASS_SERVICE_TXNS_TEMP"

View Text - HTML Formatted

SELECT MASS_SERVICE_TXN_TEMP_ID MASS_SERVICE_TXN_TEMP_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, TRANSACTION_CODE TRANSACTION_CODE
, RENEWAL_CRITERIA_SET RENEWAL_CRITERIA_SET
, CP_SERVICE_ID CP_SERVICE_ID
, 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
, RENEWAL_DURATION_QUANTITY RENEWAL_DURATION_QUANTITY
, RENEWAL_UNIT_OF_MEASURE_CODE RENEWAL_UNIT_OF_MEASURE_CODE
, RENEWAL_THROUGH_DATE RENEWAL_THROUGH_DATE
, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE
, TRANSACTION_COMMENTS TRANSACTION_COMMENTS
, ORDER_TYPE_ID ORDER_TYPE_ID
, CUSTOMER_ID CUSTOMER_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CP_SERIAL_NUMBER CP_SERIAL_NUMBER
, CP_REVISION_ID CP_REVISION_ID
, SYSTEM_ID SYSTEM_ID
, PRODUCT_AGREEMENT_ID PRODUCT_AGREEMENT_ID
, SERVICE_AGREEMENT_ID SERVICE_AGREEMENT_ID
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID
, SERVICE_MANUFACTURING_ORG_ID SERVICE_MANUFACTURING_ORG_ID
, SERVICE_START_DATE SERVICE_START_DATE
, SERVICE_END_DATE SERVICE_END_DATE
, SELECTED_FLAG SELECTED_FLAG
FROM "CS"."CS_MASS_SERVICE_TXNS_TEMP"