VIEW: APPS.XNP_SV_FE_MAPP_DETAILS_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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