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: APPS.XNP_SV_ORDER_MAPP_DETAILS_VL

Source

View Text - Preformatted


SELECT SOM.ORDER_ID , SOM.SV_SOA_ID , SOM.SV_SMS_ID , SOM.WORKITEM_INSTANCE_ID , OHR.EXTERNAL_ORDER_NUMBER , OHR.TELEPHONE_NUMBER , WOM.WORKITEM_ID , WOM.WORKITEM_NAME , WOM.WI_TYPE_CODE , WOM_TL.DISPLAY_NAME , WOM_TL.DESCRIPTION , FWT.STATUS_CODE FROM XNP_SV_ORDER_MAPPINGS SOM , XDP_ORDER_HEADERS OHR , XDP_WORKITEMS WOM , XDP_FULFILL_WORKLIST FWT , XDP_WORKITEMS_TL WOM_TL WHERE SOM.ORDER_ID = OHR.ORDER_ID AND WOM.WORKITEM_ID = FWT.WORKITEM_ID AND SOM.WORKITEM_INSTANCE_ID = FWT.WORKITEM_INSTANCE_ID AND WOM.WORKITEM_ID = WOM_TL.WORKITEM_ID AND WOM_TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT SOM.ORDER_ID
, SOM.SV_SOA_ID
, SOM.SV_SMS_ID
, SOM.WORKITEM_INSTANCE_ID
, OHR.EXTERNAL_ORDER_NUMBER
, OHR.TELEPHONE_NUMBER
, WOM.WORKITEM_ID
, WOM.WORKITEM_NAME
, WOM.WI_TYPE_CODE
, WOM_TL.DISPLAY_NAME
, WOM_TL.DESCRIPTION
, FWT.STATUS_CODE
FROM XNP_SV_ORDER_MAPPINGS SOM
, XDP_ORDER_HEADERS OHR
, XDP_WORKITEMS WOM
, XDP_FULFILL_WORKLIST FWT
, XDP_WORKITEMS_TL WOM_TL
WHERE SOM.ORDER_ID = OHR.ORDER_ID
AND WOM.WORKITEM_ID = FWT.WORKITEM_ID
AND SOM.WORKITEM_INSTANCE_ID = FWT.WORKITEM_INSTANCE_ID
AND WOM.WORKITEM_ID = WOM_TL.WORKITEM_ID
AND WOM_TL.LANGUAGE = USERENV('LANG')