APPS.GMO_DISPENSE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

SELECT msi.concatenated_segments
  FROM mtl_system_items_vl msi,
       gme_material_details gme
 WHERE gme.organization_id = msi.organization_id
   AND gme.inventory_item_id = msi.inventory_item_id
   AND gme.line_type = 1
   AND gme.line_no = 1
   AND gme.batch_id = p_batch_id;

Line: 29

SELECT msi.description
  FROM mtl_system_items_vl msi,
       gme_material_details gme
 WHERE gme.organization_id = msi.organization_id
   AND gme.inventory_item_id = msi.inventory_item_id
   AND gme.line_type = 1
   AND gme.line_no = 1
   AND gme.batch_id = p_batch_id;

Line: 52

 SELECT inventory_item_id,lot_number, dispensed_qty, dispense_uom, organization_id, dispense_id
   FROM GMO_MATERIAL_DISPENSES
  WHERE MATERIAL_STATUS = 'DISPENSD'
    AND RESERVATION_ID = P_RESERVATION_ID;

Line: 57

  SELECT nvl(sum(nvl(undispensed_qty,0)+ nvl(material_loss,0)),0)
       FROM GMO_MATERIAL_UNDISPENSES
      WHERE dispense_id = p_dispense_id;

Line: 64

 /* select total dispensed for reservation */
  OPEN C_GET_DISPENSES;

Line: 117

 SELECT inventory_item_id,lot_number, dispensed_qty, dispense_uom, organization_id, dispense_id
   FROM GMO_MATERIAL_DISPENSES
  WHERE MATERIAL_STATUS = 'DISPENSD'
    AND MATERIAL_DETAIL_ID  = P_MATERIAL_DETAIL_ID;

Line: 123

  SELECT nvl(sum(nvl(undispensed_qty,0)+ nvl(material_loss,0)),0)
       FROM GMO_MATERIAL_UNDISPENSES
      WHERE dispense_id = p_dispense_id;

Line: 179

  select dispensed_qty l_dispensed_qty
          from gmo_material_dispenses
    where  dispense_id = p_dispense_id
      and material_status = 'DISPENSD';

Line: 184

  SELECT nvl(sum(nvl(undispensed_qty,0)+ nvl(material_loss,0)),0)
    from gmo_material_undispenses u  , gmo_material_dispenses d
   where d.dispense_id = p_dispense_id
     and d.dispense_id = u.dispense_id(+)
     and d.material_status = 'DISPENSD';

Line: 199

    /* select total undispensed for material line */
    OPEN C_GET_UNDISPENSED_QTY;

Line: 416

 SELECT GMO.MATERIAL_DETAIL_ID,  GMO.INVENTORY_ITEM_ID, GMO.ORGANIZATION_ID
   FROM GMO_MATERIAL_DISPENSES GMO
  WHERE GMO.DISPENSE_ID = P_DISPENSE_ID;

Line: 471

 SELECT res.*
   FROM MTL_RESERVATIONS res,
        gme_material_Details gmd,
        gme_batch_header gbh
  WHERE res.demand_source_type_id = 5
   and res.inventory_item_id = gmd.inventory_item_id
   and  GBH.BATCH_ID = GMD.BATCH_ID
   and GBH.BATCH_STATUS in (1,2)
   and  RES.DEMAND_SOURCE_HEADER_ID = GBH.BATCH_ID
   and res.demand_source_line_id = p_material_detail_id
   and gmd.line_type = -1
   and gme_api_grp.IS_RESERVATION_FULLY_SPECIFIED(res.reservation_id) = 1;

Line: 484

  SELECT Dispense_id,
         dispensed_qty,
	 dispense_uom,
	 GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) net_dispensed_qty
  from gmo_material_dispenses
  WHERE reservation_id = p_reservation_id
    and material_status = 'DISPENSD'
    and   GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY(dispense_id) > 0;

Line: 497

  SELECT gmd.organization_id
    FROM gme_material_details gmd
   WHERE gmd.material_detail_id = p_material_detail_id;

Line: 578

           /* Select dispensed rows that can be consumed for the given reservations */
            OPEN 	C_GET_DISPENSES(l_reservation_record.reservation_id) ;

Line: 780

   SELECT MAX(dispense_id)
    FROM GMO_MATERIAL_DISPENSES
       WHERE BATCH_ID = p_batch_id;

Line: 796

   SELECT MAX(undispense_id)
    FROM GMO_MATERIAL_UNDISPENSES
   WHERE DISPENSE_ID = p_dispense_id;

Line: 999

 SELECT sum(nvl(undispensed_qty,0))
  FROM GMO_MATERIAL_UNDISPENSES
 WHERE dispense_id = p_dispense_id;

Line: 1014

 SELECT sum(nvl(material_loss,0))
  FROM GMO_MATERIAL_UNDISPENSES
 WHERE dispense_id = p_dispense_id;

Line: 1033

select count(dispense_booth_id) into countValue from gmo_material_dispenses
where dispense_booth_id = disp_booth_id;

Line: 1039

select count(dispense_booth_id) into countValue from gmo_material_undispenses
where dispense_booth_id = disp_booth_id;

Line: 1055

select count(dispense_area_id) into countValue from gmo_material_dispenses
where dispense_area_id = disp_area_id;

Line: 1061

    select count(dispense_area_id) into countValue from gmo_material_undispenses
    where dispense_area_id = disp_area_id;

Line: 1066

        select count(dispense_area_id) into countValue from gmo_dispensing_planning
        where dispense_area_id = disp_area_id;