APPS.GME_LPN_MOBILE_TXN SQL Statements

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

Line: 31

  SELECT seq_dbg.NEXTVAL INTO nxt_seq FROM DUAL;

Line: 32

    INSERT INTO nks_temp_table (STR, CREATE_DATE, SEQ) VALUES (p_message, sysdate, nxt_seq);

Line: 44

   SELECT mmtt.TRANSACTION_HEADER_ID, mmtt.TRANSACTION_TEMP_ID
   INTO txn_header_id, txn_temp_id
   FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
   WHERE move_order_line_id = mtrl.line_id
   AND mtrl.lpn_id = p_lpn_id;

Line: 91

	  SELECT wlpn.license_plate_number,
             wlpn.lpn_id,
             wlc.inventory_item_id,
             wlc.quantity
      FROM wms_license_plate_numbers wlpn,
           wms_lpn_contents wlc
      WHERE wlpn.lpn_id = wlc.parent_lpn_id (+)
        AND wlpn.organization_id = wlc.organization_id (+)
        AND wlpn.organization_id = p_org_id
        AND wlpn.license_plate_number LIKE LTRIM(RTRIM('%'||p_lpn_no||'%'))
        AND wlpn.lpn_context = 2
      ORDER BY lpad(wlpn.license_plate_number, 30);

Line: 288

   |   Update_MO_Line
   |
   | USAGE
   |
   | ARGUMENTS
   |   p_lpn_id - LPN id
   |   p_wms_process_flag - Process Flag to be updated to
   |
   | RETURNS
   |   x_return_status - S : If successful, E : If error
   |   x_msg_count - Message count
   |   x_msg_data - Message Data
   |
   | HISTORY
   |   Created  06-Oct-05 Nsinghi
   |
   +========================================================================+*/

PROCEDURE Update_MO_Line
  (p_lpn_id 				                  IN NUMBER,
   p_wms_process_flag 			            IN NUMBER,
   x_return_status                        OUT   NOCOPY VARCHAR2)
IS
  	 l_return_status		      VARCHAR2(1);

Line: 316

	UPDATE mtl_txn_request_lines
	SET wms_process_flag = p_wms_process_flag
	WHERE lpn_id = p_lpn_id;

Line: 327

END Update_MO_Line;

Line: 421

   SELECT COUNT(material_detail_id) INTO x_prod_count
   FROM gme_material_details
   WHERE batch_id = p_batch_id
   AND organization_id = p_org_id
   AND line_type IN (1, 2);

Line: 464

      SELECT gbh.batch_no, msi.concatenated_segments, gmd.subinventory, mil.concatenated_segments, inventory_location_id
      FROM gme_material_details gmd, mtl_item_locations_kfv mil, gme_batch_header gbh, mtl_system_items_kfv msi
      WHERE gmd.organization_id = p_org_id
      AND gmd.batch_id = p_batch_id
      AND gmd.material_detail_id = p_material_dtl_id
      AND gmd.locator_id = mil.inventory_location_id
      AND gmd.organization_id = mil.organization_id
      AND gmd.batch_id = gbh.batch_id
      AND gmd.organization_id = gbh.organization_id
      AND gmd.inventory_item_id = msi.inventory_item_id
      AND gmd.organization_id = msi.organization_id;