APPS.OE_PURCHASE_RELEASE_PVT dependencies on OE_ORDER_LINES

Line 113: FROM OE_ORDER_LINES

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

Line 188: FROM oe_order_lines

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

Line 444: FROM oe_order_lines

440: goto end_of_for_loop;
441: ELSE
442: SELECT shippable_flag
443: INTO l_shippable_flag
444: FROM oe_order_lines
445: WHERE line_id = l_drop_ship_line_rec.line_id;
446:
447: IF nvl(l_shippable_flag, 'N') = 'N' THEN
448: IF l_debug_level > 0 THEN

Line 1074: FROM po_location_associations pla, oe_order_lines_all sl,

1070: sl.inventory_item_id,
1071: sl.source_type_code, decode(msi.inventory_asset_flag,
1072: 'Y', mp.material_account, nvl(msi.expense_account,
1073: mp.expense_account)), nvl(pla.location_id, -1)
1074: FROM po_location_associations pla, oe_order_lines_all sl,
1075: mtl_parameters mp, fnd_user fu, mtl_system_items msi,
1076: oe_order_headers sh
1077: WHERE sl.header_id = sh.header_id
1078: AND sl.line_id = p_line_id

Line 1643: FROM oe_order_lines_all

1639: option_number || '.' ||
1640: component_number || '.' ||
1641: service_number, '.')
1642: INTO l_line_num
1643: FROM oe_order_lines_all
1644: WHERE line_id = p_request_tbl(I).entity_id;
1645:
1646: IF l_process_flag is NULL THEN
1647:

Line 1738: FROM oe_order_lines_all

1734: option_number || '.' ||
1735: component_number || '.' ||
1736: service_number, '.')
1737: INTO l_line_num
1738: FROM oe_order_lines_all
1739: WHERE line_id = p_request_tbl(I).entity_id;
1740: Exception
1741: When Others Then
1742: /* Bug 4922019: Changes done to ATO configuration resutls in