View: XNP_SV_FE_MAPP_DETAILS_VL

Product:	XNP - Number Portability
Description:	Shows subscription version data provisioned on the fulfillment element
Implementation/DBA Data:	APPS.XNP_SV_FE_MAPP_DETAILS_VL

View Text

SELECT SSE.SV_SMS_ID
, SSE.FEATURE_TYPE
, SSE.PROVISION_STATUS
, LKV.MEANING
, FES.FULFILLMENT_ELEMENT_NAME
, FES_TL.DISPLAY_NAME
, FET.FULFILLMENT_ELEMENT_TYPE
FROM XNP_SV_SMS_FE_MAPS SSE
, XDP_FES FES
, XDP_FES_TL FES_TL
, XDP_FE_TYPES FET
, FND_LOOKUP_VALUES LKV
WHERE SSE.FE_ID = FES.FE_ID
AND FES.FE_ID = FES_TL.FE_ID
AND FES_TL.LANGUAGE = USERENV('LANG')
AND FES.FETYPE_ID = FET.FETYPE_ID
AND LKV.LOOKUP_TYPE = 'XNP_PROV_STATUS'
AND SSE.PROVISION_STATUS = LKV.LOOKUP_CODE

Columns