APPS.OE_ERROR_WF dependencies on OE_ORDER_LINES_ALL

Line 306: from oe_order_lines_all

302: ELSIF err_itemtype = 'OEOL' THEN
303: l_line_id := to_number(err_itemkey);
304: select header_id
305: into l_header_id
306: from oe_order_lines_all
307: where line_id = l_line_id;
308: ELSIF err_itemtype IN ('OEOI','OESO','OEOA','OEXWFEDI') THEN
309: -- submit it if order exists
310: Get_EM_Key_Info (p_itemtype => err_itemtype,

Line 586: FROM oe_order_lines_all

582: SELECT header_id, FLOW_STATUS_CODE,
583: line_number, shipment_number, option_number, service_number
584: into l_header_id, l_flow_status_code,
585: l_line_number, l_shipment_number, l_option_number, l_service_number
586: FROM oe_order_lines_all
587: WHERE line_id = err_itemkey;
588:
589: SELECT order_number, order_type_id, order_category_code,
590: org_id, SALESREP_ID, VERSION_NUMBER

Line 1685: FROM OE_ORDER_LINES_ALL

1681:
1682: ELSIF p_item_type = 'OEOL' THEN
1683:
1684: SELECT header_id into l_hdr_id
1685: FROM OE_ORDER_LINES_ALL
1686: WHERE line_id = to_number(p_item_key)
1687: FOR UPDATE NOWAIT;
1688:
1689: SELECT order_number into l_ord_num

Line 2151: FROM OE_Order_Lines_All

2147: IF p_item_type = 'OEOL' THEN
2148: -- fetch header id to make sure index is used
2149: SELECT header_id
2150: INTO l_header_id
2151: FROM OE_Order_Lines_All
2152: WHERE line_id = to_number(l_retry_rec.item_key(i));
2153:
2154: IF l_debug_level > 0 THEN
2155: oe_debug_pub.add('Fetched header id ' || l_header_id);