[Home] [Help] [Dependency Information]
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 |
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.
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 |
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;
APPS.XNP_SV_FE_MAPP_DETAILS_VL is not referenced by any database object
|
|
|