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: XNC_SS_SYSTEM_V

Product:	XNC - Sales for Communications (Obsolete)
Description:	This view is used to retrieve system name for a given item.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT B.SOURCE_TRANSACTION_ID LINE_ID
, C.SYSTEM_NAME
FROM CSI_T_TXN_LINE_DETAILS A
, CSI_T_TRANSACTION_LINES B
, CSI_T_TXN_SYSTEMS C
WHERE A.TRANSACTION_LINE_ID = B.TRANSACTION_LINE_ID
AND A.TRANSACTION_SYSTEM_ID = C.TRANSACTION_SYSTEM_ID

Columns

Name
LINE_ID
SYSTEM_NAME