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_ORDER_MAPP_DETAILS_VL

Object Details

Object Name:	XNP_SV_ORDER_MAPP_DETAILS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XNP.XNP_SV_ORDER_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_ORDER_MAPP_DETAILS_VL holds information about the workitem instance and related order for a SOA or SMS subscription version.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_ID	NUMBER		Yes	Order id received from Oracle Provisioning
SV_SOA_ID	NUMBER			SOA identifier for the subscription version
SV_SMS_ID	NUMBER			SMS identifier for the subscription version
WORKITEM_INSTANCE_ID	NUMBER			Workitem instance id for the Order Id received from provisioning system
EXTERNAL_ORDER_NUMBER	VARCHAR2	(40)	Yes	External order number that is used by the external system to identify the order
TELEPHONE_NUMBER	VARCHAR2	(40)		Telephone Number for the subscription version
WORKITEM_ID	NUMBER		Yes	Workitem id for the workitem instance id received from provisioning system
WORKITEM_NAME	VARCHAR2	(40)	Yes	Workitem name for the Workitem instance id received from provisioning system
WI_TYPE_CODE	VARCHAR2	(40)	Yes	Type code for Workitem instance received from OP
WI_DISPLAY_NAME	VARCHAR2	(80)	Yes	Name of Workitem instance received from OP
WI_DESCRIPTION	VARCHAR2	(2000)		Workitem instance description received from provisioning system
STATUS_CODE	VARCHAR2	(40)	Yes	Status code for the Workitem instance received from provisioning system

Query Text

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


SELECT ORDER_ID
,      SV_SOA_ID
,      SV_SMS_ID
,      WORKITEM_INSTANCE_ID
,      EXTERNAL_ORDER_NUMBER
,      TELEPHONE_NUMBER
,      WORKITEM_ID
,      WORKITEM_NAME
,      WI_TYPE_CODE
,      WI_DISPLAY_NAME
,      WI_DESCRIPTION
,      STATUS_CODE
FROM APPS.XNP_SV_ORDER_MAPP_DETAILS_VL;

Dependencies

[top of page]

APPS.XNP_SV_ORDER_MAPP_DETAILS_VL references the following:

APPS: XDP_FULFILL_WORKLIST; XDP_ORDER_HEADERS; XDP_WORKITEMS; XDP_WORKITEMS_TL; XNP_SV_ORDER_MAPPINGS

APPS.XNP_SV_ORDER_MAPP_DETAILS_VL is not referenced by any database object