DBA Data[Home] [Help]

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 364: FROM oe_order_lines_all

360: ,l_change_sequence
361: ,l_source_document_type_id
362: ,l_source_document_id
363: ,l_source_document_line_id
364: FROM oe_order_lines_all
365: WHERE line_id = l_line_id;
366:
367: OE_MSG_PUB.set_msg_context(
368: p_entity_code => 'LINE'