eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_NPD_MIGRATE SQL Statements

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

Line: 31


    SELECT PROFILE_OPTION_VALUE
    FROM   Fnd_Profile_Options a, Fnd_Profile_Option_Values b
    WHERE  a.Profile_Option_Id = b.Profile_Option_Id
    AND    a.Profile_Option_Name = P_Profile_Name
    AND    level_id = 10001;

Line: 84


    SELECT orgn_code, plant_ind, organization_id, created_by,
           Last_updated_by, creation_date, last_update_date,
           Last_update_login
    FROM   sy_orgn_mst
    WHERE  plant_ind > 0
    AND    delete_mark = 0
    AND    migrated_ind = 1;

Line: 93


    SELECT 1
    FROM   sys.dual
    WHERE  EXISTS (SELECT 1
                   FROM   gmd_parameters_hdr
                   WHERE  organization_id = V_organization_id);

Line: 100


    SELECT GMD_Parameter_Id_S.nextval
    FROM dual;

Line: 152


        GMD_PARAMETERS_HDR_PKG.Insert_Row
          (X_rowid		=> l_rowid,
           X_Parameter_Id	=> l_Parameter_Id,
           X_organization_id	=> l_rec.organization_id,
           X_Lab_Ind		=> l_lab_ind,
           X_plant_Ind		=> l_plant_ind,
           X_creation_date	=> l_rec.creation_date,
           X_created_by		=> l_rec.created_by,
           X_last_update_date	=> l_rec.last_update_date,
           X_last_updated_by	=> l_rec.last_updated_by,
           X_last_update_login	=> l_rec.last_update_login);

Line: 318


    SELECT parameter_id
    FROM   gmd_parameters_hdr
    WHERE  organization_id IS NULL;

Line: 324


    SELECT 1
    FROM   sys.dual
    WHERE  EXISTS (SELECT 1
                   FROM   gmd_parameters_dtl
                   WHERE  parameter_id = V_parameter_id
                   AND    parameter_name = V_parameter);

Line: 332


	SELECT GMD_Parameter_Id_S.nextval
	FROM dual;

Line: 336


	SELECT GMD_Parameter_Line_Id_S.nextval
	FROM dual;

Line: 370


	/*Insert a row into the header table for Global organization */
	GMD_PARAMETERS_HDR_PKG.Insert_Row (	X_rowid			=> l_rowid,
						X_Parameter_Id		=> l_parameter_id,
						X_organization_id	=> NULL,
						X_Lab_Ind		=> 0,
						X_plant_Ind		=> 0,
						X_creation_date		=> SYSDATE,
						X_created_by		=> 0,
						X_last_update_date	=> SYSDATE,
						X_last_updated_by	=> 0,
						X_last_update_login	=> NULL);

Line: 431


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_Parameter_line_Id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 1,
	X_parameter_name	=> 'GMD_FORMULA_VERSION_CONTROL',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 473


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_Parameter_line_Id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 1,
	X_parameter_name	=> 'GMD_BYPRODUCT_ACTIVE',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 516


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_parameter_line_id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 1,
	X_parameter_name	=> 'GMD_ZERO_INGREDIENT_QTY',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 558


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_parameter_line_id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 1,
	X_parameter_name	=> 'GMD_MASS_UM_TYPE',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 599


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_parameter_line_id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 1,
	X_parameter_name	=> 'GMD_VOLUME_UM_TYPE',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 640


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_parameter_line_id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 1,
	X_parameter_name	=> 'FM_YIELD_TYPE',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 682


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_parameter_line_id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 1,
	X_parameter_name	=> 'FM$DEFAULT_RELEASE_TYPE',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 728


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_parameter_line_id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 4,
	X_parameter_name	=> 'GMD_RECIPE_VERSION_CONTROL',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 769


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_parameter_line_id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 4,
	X_parameter_name	=> 'GMD_PROC_INSTR_PARAGRAPH',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 815


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_parameter_line_id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 2,
	X_parameter_name	=> 'GMD_OPERATION_VERSION_CONTROL',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 861


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_parameter_line_id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 3,
	X_parameter_name	=> 'GMD_ROUTING_VERSION_CONTROL',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 902


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_parameter_line_id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 3,
	X_parameter_name	=> 'GMD_ENFORCE_STEP_DEPENDENCY',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 944


    GMD_Parameters_Dtl_Pkg.Insert_Row
    (	X_rowid			=> l_rowid,
	X_parameter_line_id	=> l_parameter_line_id,
	X_parameter_id		=> l_parameter_id,
	X_parm_Type		=> 3,
	X_parameter_name	=> 'STEPRELEASE_TYPE',
	X_parameter_value	=> l_profile_value,
	X_creation_date		=> SYSDATE,
	X_created_by		=> 0,
	X_last_update_date	=> SYSDATE,
	X_last_updated_by	=> 0,
	X_last_update_login	=> NULL);

Line: 1045


    SELECT chld.recipe_id, mst.recipe_id master_recipe_id
    FROM   gmd_recipes_b chld,
           (SELECT recipe_id, owner_organization_id, recipe_no, formula_id, routing_id
            FROM   gmd_recipes_b
            WHERE  recipe_type = 0 ) mst,
           Mtl_parameters org
    WHERE  org.master_organization_id = mst.owner_organization_id
    AND    chld.owner_organization_id = org.organization_id
    AND    mst.recipe_no = chld.recipe_no
    AND    mst.formula_id = chld.formula_id
    AND    NVL(mst.routing_id, -1) = NVL(chld.routing_id, -1)
    AND    chld.master_recipe_id IS NULL;

Line: 1080


      /* Select all the master organizations and update them to "General" recipe type */
      UPDATE gmd_recipes_b
         SET recipe_type = 0
       WHERE recipe_type IS NULL
	 AND owner_organization_id IN ( SELECT DISTINCT owner_organization_id
					  FROM gmd_recipes_b r
					 WHERE EXISTS (SELECT 1
					                 FROM mtl_parameters o
						        WHERE o.master_organization_id = r.owner_organization_id));

Line: 1090


      /* Now lets update the rest of the recipe types as "Site" */
      UPDATE gmd_recipes_b
      SET recipe_type = 1
      WHERE recipe_type IS NULL;

Line: 1095


      /* Now lets update the master recipe id for the recipes */
      FOR l_recipe_rec IN Cur_get_recipe LOOP
        UPDATE gmd_recipes_b
        SET master_recipe_id = l_recipe_rec.master_recipe_id
        WHERE recipe_id = l_recipe_rec.recipe_id;

Line: 1180


  PROCEDURE update_lab_simulator (P_migration_run_id	IN  NUMBER,
				  P_commit		IN  VARCHAR2,
				  X_failure_count	OUT NOCOPY NUMBER) IS
    CURSOR Cur_get_orgn (V_orgn_code VARCHAR2) IS
      SELECT organization_id
      FROM   sy_orgn_mst_b
      WHERE  orgn_code = V_orgn_code
      AND    migrated_ind = 1;

Line: 1222


      UPDATE lm_sprd_fls
      SET    lab_organization_id = l_organization_id
      WHERE  lab_organization_id IS NULL;

Line: 1290


  END update_lab_simulator;