APPS.GMA_MIGRATION_UTILS SQL Statements

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

Line: 25

      SELECT  reason_id
      FROM sy_reas_cds_b
      WHERE reason_code = p_reason_code;

Line: 54

      SELECT organization_id
      FROM   sy_orgn_mst
      WHERE  orgn_code = P_orgn_code;

Line: 83

      SELECT uom_code
      FROM   sy_uoms_mst
      WHERE  um_code = P_um_code;

Line: 154

      SELECT ic.text_code,
             ic.item_no,
	     msi.inventory_item_id,
             msi.organization_id,
             msi.segment1
       FROM  mtl_system_items msi,
             mtl_parameters p,
             ic_item_mst ic
      WHERE  msi.segment1 = ic.item_no
        AND  msi.organization_id = p.master_organization_id
        AND  p.organization_id = p.master_organization_id
        AND  ic.text_code IS NOT NULL;

Line: 170

      SELECT p.lot_number,
             itm.INVENTORY_ITEM_ID,
	     p.organization_id,
	     ic.text_code
       FROM  ic_item_mst_b_mig itm,
             mtl_lot_numbers  msi,
             IC_LOTS_MST_MIG p,
             IC_LOTS_MST ic
      WHERE  p.lot_number = msi.lot_number
             AND p.item_id = itm.item_id
	     AND p.lot_id = ic.lot_id
	     AND p.organization_id = itm.organization_id
             AND  ic.text_code IS NOT NULL;

Line: 187

      SELECT mgb.grade_code,
             opm.text_code
       FROM  MTL_GRADES_B MGB,
             GMD_GRADES_B opm
       WHERE  opm.qc_grade = mgb.grade_code
       AND  opm.text_code IS NOT NULL;

Line: 198

      SELECT mac.action_code,
             opm.text_code
       FROM  MTL_ACTIONS_B MAC,
             GMD_ACTIONS_B opm
       WHERE  opm.action_code = mac.action_code
       AND  opm.text_code IS NOT NULL;

Line: 210

         SELECT src.text_code,
                 src.reason_id,
		 src.reason_code
          FROM SY_REAS_CDS_B src
          WHERE src.text_code IS NOT NULL
	  and src.reason_id <> 0;

Line: 220

         SELECT som.text_code,
                som.organization_id,
		som.orgn_code
          FROM SY_ORGN_MST som
          WHERE som.text_code IS NOT NULL
	  and som.migrate_as_ind=3;

Line: 282

	    -- Update the CCM logs

	     FND_MESSAGE.SET_NAME('GMA', 'GMA_TEXT_CODE_FAILURE');

Line: 359

	     -- Update the CCM Logs
	     FND_MESSAGE.SET_NAME('GMA', 'GMA_TEXT_CODE_FAILURE');

Line: 430

	     -- Update the CCM logs
	     FND_MESSAGE.SET_NAME('GMA', 'GMA_TEXT_CODE_FAILURE');

Line: 503

	     -- Update the CCM logs
	     FND_MESSAGE.SET_NAME('GMA', 'GMA_TEXT_CODE_FAILURE');

Line: 576

	     -- Update the CCM logs

	     FND_MESSAGE.SET_NAME('GMA', 'GMA_TEXT_CODE_FAILURE');

Line: 652

	     -- Update the CCM logs

	     FND_MESSAGE.SET_NAME('GMA', 'GMA_TEXT_CODE_FAILURE');