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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.XNP_SV_FE_MAPP_DETAILS_VL

Object Details

Object Name:	XNP_SV_FE_MAPP_DETAILS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XNP.XNP_SV_FE_MAPP_DETAILS_VL
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

XNP_SV_FE_MAPP_DETAILS_VL stores the fulfillment elements provisioned with the subscription version data for a given feature type.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SV_SMS_ID	NUMBER		Yes	SMS subscription version identifier
FEATURE_TYPE	VARCHAR2	(15)	Yes	Feature type for which the network element is to be provisioned
PROVISION_STATUS	VARCHAR2	(20)	Yes	Provisioning status of the network element
PROVISION_STATUS_MEANING	VARCHAR2	(80)	Yes	Meaning of the status code used to provision the network element
FULFILLMENT_ELEMENT_NAME	VARCHAR2	(40)	Yes	Name of fulfillment element or network element
DISPLAY_NAME	VARCHAR2	(80)	Yes	Display name for the network element
FULFILLMENT_ELEMENT_TYPE	VARCHAR2	(40)	Yes	Type of fulfillment element

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SV_SMS_ID
,      FEATURE_TYPE
,      PROVISION_STATUS
,      PROVISION_STATUS_MEANING
,      FULFILLMENT_ELEMENT_NAME
,      DISPLAY_NAME
,      FULFILLMENT_ELEMENT_TYPE
FROM APPS.XNP_SV_FE_MAPP_DETAILS_VL;

Dependencies

[top of page]

APPS.XNP_SV_FE_MAPP_DETAILS_VL references the following:

APPS: FND_LOOKUP_VALUES; XDP_FES; XDP_FES_TL; XDP_FE_TYPES; XNP_SV_SMS_FE_MAPS

APPS.XNP_SV_FE_MAPP_DETAILS_VL is not referenced by any database object