APPS.OE_PURCHASE_RELEASE_PVT dependencies on OE_ORDER_LINES

Line 115: FROM OE_ORDER_LINES

111: FROM oe_order_headers
112: WHERE header_id = x_header_id;
113: Cursor Req_Date (v_line_id NUMBER) is
114: SELECT REQUEST_DATE
115: FROM OE_ORDER_LINES
116: WHERE LINE_ID = v_line_id;
117:
118: --
119: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 190: FROM oe_order_lines

186: END IF;
187:
188: SELECT item_type_code, ato_line_id
189: INTO l_item_type_code, l_ato_line_id
190: FROM oe_order_lines
191: WHERE line_id = l_drop_ship_line_rec.line_id;
192:
193: IF (l_item_type_code = 'MODEL' OR
194: l_item_type_code = 'KIT' OR

Line 479: FROM oe_order_lines

475: goto end_of_for_loop;
476: ELSE
477: SELECT shippable_flag
478: INTO l_shippable_flag
479: FROM oe_order_lines
480: WHERE line_id = l_drop_ship_line_rec.line_id;
481:
482: IF nvl(l_shippable_flag, 'N') = 'N' THEN
483: IF l_debug_level > 0 THEN

Line 1109: FROM po_location_associations pla, oe_order_lines_all sl,

1105: sl.inventory_item_id,
1106: sl.source_type_code, decode(msi.inventory_asset_flag,
1107: 'Y', mp.material_account, nvl(msi.expense_account,
1108: mp.expense_account)), nvl(pla.location_id, -1)
1109: FROM po_location_associations pla, oe_order_lines_all sl,
1110: mtl_parameters mp, fnd_user fu, mtl_system_items msi,
1111: oe_order_headers sh
1112: WHERE sl.header_id = sh.header_id
1113: AND sl.line_id = p_line_id

Line 1678: FROM oe_order_lines_all

1674: option_number || '.' ||
1675: component_number || '.' ||
1676: service_number, '.')
1677: INTO l_line_num
1678: FROM oe_order_lines_all
1679: WHERE line_id = p_request_tbl(I).entity_id;
1680:
1681: IF l_process_flag is NULL THEN
1682:

Line 1773: FROM oe_order_lines_all

1769: option_number || '.' ||
1770: component_number || '.' ||
1771: service_number, '.')
1772: INTO l_line_num
1773: FROM oe_order_lines_all
1774: WHERE line_id = p_request_tbl(I).entity_id;
1775: Exception
1776: When Others Then
1777: /* Bug 4922019: Changes done to ATO configuration resutls in