2698: SELECT COUNT(1)
2699: FROM ic_txn_request_lines mo,
2700: oe_order_lines_all l,
2701: oe_order_headers_all h,
2702: oe_transaction_types_all ta,
2703: oe_transaction_types_tl tt
2704: WHERE l.header_id = h.header_id
2705: AND l.line_id = mo.txn_source_line_id
2706: AND tt.transaction_type_id = ta.transaction_type_id
2735: mo.inventory_item_id
2736: FROM ic_txn_request_lines mo,
2737: oe_order_lines_all l,
2738: oe_order_headers_all h,
2739: oe_transaction_types_all ta,
2740: oe_transaction_types_tl tt
2741: WHERE l.header_id = h.header_id
2742: AND l.line_id = mo.txn_source_line_id
2743: AND tt.transaction_type_id = ta.transaction_type_id