APPS.OE_RESERVE_CONC dependencies on OE_RSV_SET_DETAILS

Line 283: FROM oe_rsv_set_details

279: ship_from_org_id,
280: subinventory,
281: corrected_qty,
282: corrected_qty2 -- INVCONV
283: FROM oe_rsv_set_details
284: WHERE reservation_set_id = p_reservation_set_id
285: AND line_id = p_line_id;
286:
287: TYPE Rsv_set_rec_type IS RECORD

Line 469: into oe_reservation_sets and oe_rsv_set_details table.

465:
466: /*------------------------------------------------------
467: Procedure Name : Create_Reservation_Set
468: Description : Inserts simulated or reserved records
469: into oe_reservation_sets and oe_rsv_set_details table.
470: --------------------------------------------------------------------- */
471: Procedure Create_Reservation_Set(p_rsv_tbl IN OE_RESERVE_CONC.Rsv_Tbl_Type,
472: p_reserve_set_name IN VARCHAR2,
473: p_rsv_request_id IN NUMBER DEFAULT NULL,

Line 500: DELETE oe_rsv_set_details

496: FROM oe_reservation_sets
497: WHERE reservation_set_name = P_reserve_set_name;
498: g_set_id := l_set_id;
499: -- Deleting the existing records.
500: DELETE oe_rsv_set_details
501: WHERE reservation_set_id = l_set_id;
502:
503: DELETE oe_reservation_sets
504: WHERE reservation_set_id = l_set_id;

Line 556: INSERT INTO oe_rsv_set_details

552: FOR I IN 1..p_rsv_tbl.COUNT
553: LOOP
554: l_line_count := l_line_count + 1;
555:
556: INSERT INTO oe_rsv_set_details
557: (Reservation_set_id
558: ,Line_id
559: ,header_id
560: ,inventory_item_id

Line 2445: l_stmt := 'SELECT l.Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ,MTL_SYSTEM_ITEMS msi,oe_rsv_set_details rs ';

2441: --Moac
2442: l_stmt := 'SELECT Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ,MTL_SYSTEM_ITEMS msi ';
2443: --10241113
2444: IF p_selected_ids IS NOT NULL THEN
2445: l_stmt := 'SELECT l.Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ,MTL_SYSTEM_ITEMS msi,oe_rsv_set_details rs ';
2446: END IF;
2447: l_stmt := l_stmt|| ' WHERE NVL(h.cancelled_flag,'||'''N'''||') <> ' ||'''Y'''||
2448: ' AND h.header_id = l.header_id'||
2449: ' AND h.open_flag = '||'''Y'''||

Line 2525: oe_rsv_set_details WHERE reservation_set_id=:set_id)';

2521: --R12.MOAC
2522: --10241113
2523: /*
2524: l_stmt := l_stmt ||' AND l.line_id IN(SELECT line_id FROM
2525: oe_rsv_set_details WHERE reservation_set_id=:set_id)';
2526: */
2527: l_stmt := l_stmt ||' AND l.line_id = rs.line_id AND reservation_set_id=:set_id ';
2528: l_ord_by :=' rs.line_sequence,';
2529: END IF;

Line 3022: DELETE FROM oe_rsv_set_details

3018: END IF;
3019: END IF; -- Pack J
3020: --R12.MOAC
3021: IF p_selected_ids IS NOT NULL THEN
3022: DELETE FROM oe_rsv_set_details
3023: WHERE reservation_set_id = p_selected_ids;
3024: END IF;
3025:
3026: COMMIT;