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_TERMINATION_INTERFACE_ALL#

Source

View Text - Preformatted


select TERMINATION_INTERFACE_ID TERMINATION_INTERFACE_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, CP_SERVICE_TRANSACTION_ID CP_SERVICE_TRANSACTION_ID, TERMINATION_START_DATE TERMINATION_START_DATE, TERMINATION_END_DATE TERMINATION_END_DATE, CREDIT_AMOUNT CREDIT_AMOUNT, REASON_CODE REASON_CODE, REASON_MEANING REASON_MEANING, REASON_COMMENTS REASON_COMMENTS, TERMINATION_CANCELLED_CODE TERMINATION_CANCELLED_CODE, CONCURRENT_PROCESS_ID CONCURRENT_PROCESS_ID, CP_SERIAL_NUMBER CP_SERIAL_NUMBER, CP_REVISION CP_REVISION, CP_QUANTITY CP_QUANTITY, CP_ORDER_NUMBER CP_ORDER_NUMBER, CP_ORDER_DATE CP_ORDER_DATE, SERVICE_DESCRIPTION SERVICE_DESCRIPTION, CP_SERVICE_ID CP_SERVICE_ID, ORG_ID ORG_ID from "CS"."CS_TERMINATION_INTERFACE_ALL"

View Text - HTML Formatted

SELECT TERMINATION_INTERFACE_ID TERMINATION_INTERFACE_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, CP_SERVICE_TRANSACTION_ID CP_SERVICE_TRANSACTION_ID
, TERMINATION_START_DATE TERMINATION_START_DATE
, TERMINATION_END_DATE TERMINATION_END_DATE
, CREDIT_AMOUNT CREDIT_AMOUNT
, REASON_CODE REASON_CODE
, REASON_MEANING REASON_MEANING
, REASON_COMMENTS REASON_COMMENTS
, TERMINATION_CANCELLED_CODE TERMINATION_CANCELLED_CODE
, CONCURRENT_PROCESS_ID CONCURRENT_PROCESS_ID
, CP_SERIAL_NUMBER CP_SERIAL_NUMBER
, CP_REVISION CP_REVISION
, CP_QUANTITY CP_QUANTITY
, CP_ORDER_NUMBER CP_ORDER_NUMBER
, CP_ORDER_DATE CP_ORDER_DATE
, SERVICE_DESCRIPTION SERVICE_DESCRIPTION
, CP_SERVICE_ID CP_SERVICE_ID
, ORG_ID ORG_ID
FROM "CS"."CS_TERMINATION_INTERFACE_ALL"