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_ORDER_LINE_SUBSCRIPTION_V

Product:	XNC - Sales for Communications (Obsolete)
Description:	This view gives subscription for a given Order Line.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT UNIQUE OL.HEADER_ID
, OL.LINE_ID
, OL.ORG_ID
, OL.INVENTORY_ITEM_ID
, CT.NAME SUBSCRIPTION
FROM CSI_T_TXN_LINE_DETAILS A
, CSI_T_TRANSACTION_LINES B
, CSI_SYSTEMS_B CSS
, CSI_SYSTEMS_TL CT
, OE_ORDER_LINES_ALL OL
WHERE OL.LINE_ID = B.SOURCE_TRANSACTION_ID
AND B.TRANSACTION_LINE_ID = A.TRANSACTION_LINE_ID
AND CSS.SYSTEM_ID(+) = A.CSI_SYSTEM_ID
AND CSS.SYSTEM_ID = CT.SYSTEM_ID (+)
AND CT.LANGUAGE (+)= USERENV('LANG')

Columns

Name
HEADER_ID
LINE_ID
ORG_ID
INVENTORY_ITEM_ID
SUBSCRIPTION