DBA Data[Home] [Help]

APPS.GMD_SPREADSHEET_UPDATE dependencies on MTL_RESERVATIONS

Line 673: FROM mtl_reservations e

669: X_return_status OUT NOCOPY VARCHAR2) IS
670:
671: CURSOR Cur_get_del_lines (V_material_detail_id NUMBER) IS
672: SELECT *
673: FROM mtl_reservations e
674: WHERE demand_source_header_id = P_batch_id
675: AND demand_source_line_id = V_material_detail_id
676: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
677: AND NOT EXISTS (SELECT 1

Line 711: FROM mtl_reservations

707: ORDER BY CREATION_DATE DESC;
708:
709: CURSOR Cur_get_qty (V_reservation_id NUMBER) IS
710: SELECT reservation_quantity
711: FROM mtl_reservations
712: WHERE reservation_id = V_reservation_id;
713:
714: CURSOR Cur_req_date IS
715: SELECT material_requirement_date