APPS.XDP_PERF_BM_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 177

	select	null
	from	xdp_order_headers xoh
	where
		xoh.external_order_number like (p_prefix)
		and xoh.external_order_version = '1'
		and xoh.order_type = 'BENCHMARK'
	;

Line: 187

         SELECT sva.action_code
           FROM xdp_service_val_acts sva
          WHERE sva.organization_id       = p_organization_id
            AND sva.inventory_item_id     = p_inventory_item_id  ;

Line: 194

         SELECT concatenated_segments  service_name
           FROM mtl_system_items_vl  msi
          WHERE msi.organization_id       = p_organization_id
            AND msi.inventory_item_id     = p_inventory_item_id  ;

Line: 543

		select	SUM(XOH.COMPLETION_DATE - XOH.PROVISIONING_DATE) ElapseTime,
			count(*) OrderCount
		from	xdp_order_headers XOH
		where	XOH.EXTERNAL_ORDER_NUMBER like (OrderPrefix)
			AND XOH.status_code = 'SUCCESS'
			AND XOH.EXTERNAL_ORDER_VERSION = '1'
			AND XOH.ORDER_TYPE = 'BENCHMARK'
		;

Line: 553

		select	min(XOH.provisioning_date) ProvDate,
			max(XOH.completion_date) CompDate
		from	xdp_order_headers XOH
		where	XOH.EXTERNAL_ORDER_NUMBER like (OrderPrefix)
			AND XOH.status_code = 'SUCCESS'
			AND XOH.EXTERNAL_ORDER_VERSION = '1'
			AND XOH.ORDER_TYPE = 'BENCHMARK'
		;

Line: 580

  SELECT count(*) INTO total_processed_orders
  FROM	xdp_order_headers h
  WHERE
	h.external_order_number like search_prefix
	and h.external_order_version = '1'
	and h.order_type = 'BENCHMARK';