View: XNP_SV_ORDER_MAPP_DETAILS_VL

Product:	XNP - Number Portability
Description:	Shows the orders related to a given subscription version
Implementation/DBA Data:	APPS.XNP_SV_ORDER_MAPP_DETAILS_VL

View Text

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')

Columns