APPS.OE_FULFILL_WF dependencies on OE_ORDER_LINES_ALL

Line 49: FROM oe_order_lines_all

45: IF itemtype = OE_GLOBALS.G_WFI_LIN THEN
46: -- Bug 4875015
47: SELECT item_type_code,shippable_flag,top_model_line_id, service_reference_type_code
48: INTO l_item_type,l_shippable_flag,l_top_model_line_id, l_service_reference_type_code
49: FROM oe_order_lines_all
50: WHERE line_id = to_number(itemkey);
51:
52: IF l_top_model_line_id IS NOT NULL AND
53: nvl(l_shippable_flag,'N') = 'N' THEN

Line 71: FROM oe_order_lines_all

67: IF l_service_reference_type_code = 'ORDER' THEN
68:
69: SELECT header_id,service_reference_line_id
70: INTO l_header_id,l_service_ref_line_id
71: FROM oe_order_lines_all
72: WHERE line_id = to_number(itemkey)
73: AND service_reference_type_code = 'ORDER';
74:
75:

Line 78: FROM oe_order_lines_all

74:
75:
76: SELECT header_id,shippable_flag
77: INTO l_service_header_id,l_service_ship_flag
78: FROM oe_order_lines_all
79: WHERE line_id = l_service_ref_line_id;
80:
81:
82: IF l_header_id = l_service_header_id AND

Line 356: FROM oe_order_lines_all

352: ,l_change_sequence
353: ,l_source_document_type_id
354: ,l_source_document_id
355: ,l_source_document_line_id
356: FROM oe_order_lines_all
357: WHERE line_id = l_line_id;
358:
359: OE_MSG_PUB.set_msg_context(
360: p_entity_code => 'LINE'