APPS.GMO_DISPENSE_PVT dependencies on MTL_RESERVATIONS

Line 472: FROM MTL_RESERVATIONS res,

468: x_dispense_data OUT NOCOPY GME_COMMON_PVT.reservations_tab)
469: IS
470: CURSOR C_GET_RESERVATIONS IS
471: SELECT res.*
472: FROM MTL_RESERVATIONS res,
473: gme_material_Details gmd,
474: gme_batch_header gbh
475: WHERE res.demand_source_type_id = 5
476: and res.inventory_item_id = gmd.inventory_item_id

Line 492: l_reservation_record mtl_reservations%ROWTYPE;

488: from gmo_material_dispenses
489: WHERE reservation_id = p_reservation_id
490: and material_status = 'DISPENSD'
491: and GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) > 0;
492: l_reservation_record mtl_reservations%ROWTYPE;
493: l_dispense_record C_GET_DISPENSES%ROWTYPE;
494: l_result_record mtl_reservations%ROWTYPE;
495: l_Pending_reservations_tab GME_COMMON_PVT.reservations_tab;
496: CURSOR C_GET_MATERIAL_LINE IS

Line 494: l_result_record mtl_reservations%ROWTYPE;

490: and material_status = 'DISPENSD'
491: and GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) > 0;
492: l_reservation_record mtl_reservations%ROWTYPE;
493: l_dispense_record C_GET_DISPENSES%ROWTYPE;
494: l_result_record mtl_reservations%ROWTYPE;
495: l_Pending_reservations_tab GME_COMMON_PVT.reservations_tab;
496: CURSOR C_GET_MATERIAL_LINE IS
497: SELECT gmd.organization_id
498: FROM gme_material_details gmd