XDP Views (54)

XDP - Provisioning — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`XDP_ACTION_CODES_V`
`XDP_ACTION_CODES_VL`
`XDP_ADAPTER_ADMIN_REQS_V`	Adapter specific pending jobs
`XDP_ADAPTER_AUDIT_V`	Audit information about all completed administtration requests for adapters
`XDP_ADAPTER_CONNS_COUNT_V`
`XDP_ADAPTER_JOB_QUEUE_V`	This view is used as an internal queue table. When the Fulfillment Action(FA) workflow tries to execute a fulfillment procedure(FP) for f
`XDP_ADAPTER_REG_V`	Stores configuration data pertaining to all Adapters
`XDP_ADAPTER_SUMMARY_V`	View representing summary information of all Adapters defined for a Fulfillment Element. Indicates the Fulfillment Element name, the number
`XDP_ADAPTER_TYPES_VL`	Shows all seeded and user defined Adapter Types
`XDP_ADAPTER_TYPE_ATTRS_VL`	Provides a complete view of the attributes for seeded and custom adapter-types.
`XDP_ADAPTER_TYPE_REQ_TYPES_V`	Provides a view of the valid request/control operations for every adapter type
`XDP_ADAPTER_TYPE_V`	View representing the type of Adapters which have been defined for the Fulfillment Element. Indicates the Fulfillment Element identifier, t
`XDP_DQ_CONFIGURATION_VL`	View for queue configuration tables
`XDP_ERROR_LOG_V`	Shows MLS compliant error messages belonging to different application entities (Order, Adapters, etc).
`XDP_EVENTS_V`	View to get information on the internal Events raised in SFM.
`XDP_FA_PARAMETERS_DISP_V`	View representing the parameters which can be used in the FP. The evaluation procedure allows a user to specify the business logic for eva
`XDP_FA_PARAMETERS_V`	View representing the parameters which can be used in the FP. The evaluation procedure allows a user to specify the business logic for eva
`XDP_FES_VL`	The XDP_FES_VL view will hold all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillme
`XDP_FE_ATTRIBUTE_DEF_VL`	This View shows all the Fulfillment Element Attribute Definitions
`XDP_FE_ATTRIBUTE_VAL_VL`	This view contains the configuration data for SFM to communicate with a given fulfillmentelement. Example: 144.126.174.151 is the IP addres
`XDP_FE_GENERIC_CONFIG_V`	This View gives information about current and future software generics
`XDP_FE_SUMMARY_V`	View representing summary information of all Fulfillment Elements. Indicates the Fulfillment Element name, the application mode for all ad
`XDP_FE_SW_GEN_LOOKUP_VL`	This View shows all the Fulfillment Element Software Generics for the Fulfillment Element Type
`XDP_FE_TYPES_VL`	This View shows the definition of Fulfillment Element Types.
`XDP_FMC_V`	This view is used to retrieve workflow notifications
`XDP_FULFILL_ACTIONS_VL`	This View shows all the Fulfillment Actions
`XDP_INBOUND_MESSAGES_V`	This View shows the information on all the Inbound Messages.
`XDP_LOOKUPS`	XDP Lookups
`XDP_OE_ORDER_DETAILS_V`	This view contains the details for a particular order.
`XDP_ORDER_DETAILS_V`	This view contains an order details such as line items, work items, services and packages.
`XDP_ORU_ORDERS_V`	This view contains the details of resubmitted orders.
`XDP_OUTBOUND_MESSAGES_V`	This View shows the information on all the Outbound Messages.
`XDP_PARAMETER_POOL_VL`	Modified to go against FND_LOOKUPS for 11.5.6
`XDP_PEND_ORDER_V`	This View shows all the Orders in the Pending Order Queue.
`XDP_PROC_BODY_VL`	This View shows all the User defined Procedures in SFM
`XDP_PROFILE_OPTIONS_V`	This View shows all the Profile Option for XDP and XNP.
`XDP_READY_FAS_V`	This View shows all the Orders in the Fulfillment Actions Queue.
`XDP_READY_FES_V`	This View shows all the Orders in the Fulfillment Elements Ready Queue
`XDP_READY_ORDER_V`	This View shows all the Orders in the Order Ready Queue
`XDP_READY_WORKITEM_V`	This View shows all the Orders in the Ready Work Item Queue
`XDP_SERVICES_VL`	The view XDP_SERVICES_VL holds all the names assigned to a service offered by a service provider. NOTE: A service can also be a product nam
`XDP_SERVICE_PACKAGES_VL`
`XDP_SERVICE_PKG_DET_VL`
`XDP_SERVICE_VAL_ACTS_VL`	The view XDP_SERVICE_VAL_ACTS_VL is used to define the valid sales action for a given service. For example, the action 'ADD' for service '
`XDP_SERVICE_WI_MAP_VL`	The view XDP_SERVICE_WI_MAPPING_VL is used define the list of workitem which need to be executed to fulfill the given service sales action.
`XDP_SUMMARY_QUEUES_V`	This View shows the State of all the Queues
`XDP_SVE_PKG_DET_DISP_V`	This view holds all the services contained within a package.
`XDP_SVE_VAL_ACTION_DISP_V`	The view XDP_SERVICE_VAL_ACTION_DISP_V is used to define the valid sales action for a given service. For example, the action 'ADD' for ser
`XDP_SVE_WI_MAPPING_DISP_V`	The view XDP_SERVICE_WI_MAPPING_DISP_V is used define the list of workitem which need to be executed to fulfill the given service sales acti
`XDP_WAITING_FES_V`	This View shows all the Orders Waiting for the Fulfillment Elements
`XDP_WI_FA_MAPPING_DISP_V`	The view XDP_WI_FA_MAPPING_DISP_V defines the list of Fulfillment Actions to be excuted in order to fulfill a given workitem.
`XDP_WI_FA_MAPPING_VL`	The view XDP_WI_FA_MAPPING_VL defines the list of Fulfillment Actions to be excuted in order to fulfill a given workitem.
`XDP_WI_PARAMETERS_DISP_V`	The view XDP_WI_PARAMETERS_DISP_V holds all the Workitem parameters and associated properties for a given Work Item. The value_lookup_sql
`XDP_WORKITEMS_VL`	The view XDP_WORKITEMS_VL is used to define an SFM workitem. An SFM workitem can be viewed as a job to fulfill a service offering/sales a