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_SYSTEM_V

Product:	XNC - Sales for Communications (Obsolete)
Description:	XNC_ORDER_LINE_SYSTEM_V retrieves the system key for an order line.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DISTINCT OOL.LINE_ID ORDER_LINE_ID
, CS.NAME SYSTEM_NAME
FROM CS_SYSTEMS_ALL_VL CS
, CS_CP_REVISIONS CCR
, CS_CUSTOMER_PRODUCTS_ALL CCP
, CS_LINE_INST_DETAILS CLID
, ASO_I_OE_ORDER_LINES_V OOL
WHERE OOL.LINE_ID = NVL(CCR.ORDER_LINE_ID
, NVL(CCP.ORIGINAL_ORDER_LINE_ID
, CLID.ORDER_LINE_ID))
AND CCP.CUSTOMER_PRODUCT_ID = CCR.CUSTOMER_PRODUCT_ID
AND CCP.MOST_RECENT_FLAG = 'Y'
AND NVL(CCP.SYSTEM_ID
, CLID.SYSTEM_ID) = CS.SYSTEM_ID
AND CCP.ORIGINAL_ORDER_LINE_ID = CLID.ORDER_LINE_ID(+)

Columns

Name
ORDER_LINE_ID
SYSTEM_NAME