APPS.XDP_PERF_BM_PKG dependencies on XDP_ORDER_HEADERS

Line 178: from xdp_order_headers xoh

174: e_ActionCodeException exception;
175:
176: cursor cCheckUniquePrefix(p_prefix varchar2) IS
177: select null
178: from xdp_order_headers xoh
179: where
180: xoh.external_order_number like (p_prefix)
181: and xoh.external_order_version = '1'
182: and xoh.order_type = 'BENCHMARK'

Line 545: from xdp_order_headers XOH

541: IS
542: cursor orders_all(OrderPrefix varchar2) is
543: select SUM(XOH.COMPLETION_DATE - XOH.PROVISIONING_DATE) ElapseTime,
544: count(*) OrderCount
545: from xdp_order_headers XOH
546: where XOH.EXTERNAL_ORDER_NUMBER like (OrderPrefix)
547: AND XOH.status_code = 'SUCCESS'
548: AND XOH.EXTERNAL_ORDER_VERSION = '1'
549: AND XOH.ORDER_TYPE = 'BENCHMARK'

Line 555: from xdp_order_headers XOH

551:
552: cursor orders_complete(OrderPrefix varchar2) is
553: select min(XOH.provisioning_date) ProvDate,
554: max(XOH.completion_date) CompDate
555: from xdp_order_headers XOH
556: where XOH.EXTERNAL_ORDER_NUMBER like (OrderPrefix)
557: AND XOH.status_code = 'SUCCESS'
558: AND XOH.EXTERNAL_ORDER_VERSION = '1'
559: AND XOH.ORDER_TYPE = 'BENCHMARK'

Line 581: FROM xdp_order_headers h

577:
578: search_prefix := 'XDPPERFBM_' || order_number_prefix||'_%';
579:
580: SELECT count(*) INTO total_processed_orders
581: FROM xdp_order_headers h
582: WHERE
583: h.external_order_number like search_prefix
584: and h.external_order_version = '1'
585: and h.order_type = 'BENCHMARK';