APPS.GMF_VALIDATIONS_PVT SQL Statements

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

Line: 98

    SELECT
      calendar_code
    FROM
      cm_cldr_hdr
    WHERE
        calendar_code = p_calendar_code
    AND delete_mark    = 0;

Line: 159

    SELECT
      co_code, cost_mthd_code
    FROM
      cm_cldr_hdr
    WHERE
        calendar_code = p_calendar_code
    AND delete_mark    = 0;

Line: 222

    SELECT
      period_status
    FROM
      cm_cldr_dtl
    WHERE
        calendar_code 	= p_calendar_code
    AND period_code 	= p_period_code
    AND delete_mark    	= 0;

Line: 286

    SELECT
      cost_mthd_code, lot_actual_cost
    FROM
      cm_mthd_mst
    WHERE
        cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
    AND cm_mthd_mst.delete_mark    = 0;

Line: 363

    SELECT
      cost_type, rmcalc_type, prodcalc_type, lot_actual_cost
    FROM
      cm_mthd_mst
    WHERE
        cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
    AND cm_mthd_mst.delete_mark    = 0;

Line: 437

    SELECT
	cost_analysis_code
    FROM
	cm_alys_mst
    WHERE
	cost_analysis_code = p_Cost_Analysis_Code
    AND delete_mark = 0;

Line: 500

    SELECT
        co_code
    FROM
        sy_orgn_mst
    WHERE
        co_code 	= p_Company_Code
    AND orgn_code 	= co_code
    AND delete_mark	= 0;

Line: 562

    SELECT
        orgn_code
    FROM
        sy_orgn_mst
    WHERE
    	orgn_code       = p_orgn_code
    AND delete_mark     = 0;

Line: 624

    SELECT
        whse_code
    FROM
        ic_whse_mst
    WHERE
        whse_code       = p_whse_code
    AND delete_mark     = 0;

Line: 686

    SELECT
        Item_Id
    FROM
        ic_item_mst
    WHERE
        Item_Id       = p_Item_Id
    AND delete_mark   = 0
    AND inactive_ind  = 0 ;

Line: 749

    SELECT
           Item_UM
    FROM
           ic_item_mst
    WHERE
           Item_Id       = p_Item_Id
    AND    delete_mark   = 0
    AND    inactive_ind  = 0 ;

Line: 802

    SELECT
        Item_Id
    FROM
        ic_item_mst
    WHERE
        Item_No       = p_Item_No
    AND delete_mark   = 0
    AND inactive_ind  = 0 ;

Line: 866

    SELECT
        Item_Id, Item_UM
    FROM
        ic_item_mst
    WHERE
        Item_No       = p_Item_No
    AND delete_mark   = 0
    AND inactive_ind  = 0 ;

Line: 920

  SELECT
	itemcost_class
  FROM
	ic_cost_cls
  WHERE
	itemcost_class = p_itemcost_class
  AND 	delete_mark    = 0;

Line: 981

    SELECT
         Cost_Cmpntcls_Id
    FROM
         cm_cmpt_mst
    WHERE
         Cost_Cmpntcls_Id = p_Cost_Cmpntcls_Id
    AND  delete_mark = 0 ;

Line: 1043

    SELECT
         cost_cmpntcls_code, usage_ind
    FROM
         cm_cmpt_mst
    WHERE
         Cost_Cmpntcls_Id = p_Cost_Cmpntcls_Id
    AND  delete_mark = 0 ;

Line: 1104

    SELECT
         Cost_Cmpntcls_Id
    FROM
         cm_cmpt_mst
    WHERE
         Cost_Cmpntcls_Code = p_Cost_Cmpntcls_Code
    AND  delete_mark        = 0 ;

Line: 1167

    SELECT
         Cost_Cmpntcls_Id, Usage_Ind
    FROM
         cm_cmpt_mst
    WHERE
         Cost_Cmpntcls_Code = p_Cost_Cmpntcls_Code
    AND  delete_mark        = 0 ;

Line: 1230

    SELECT
	 icgl_class
    FROM
	 ic_gled_cls
    WHERE
	ic_gled_cls.icgl_class  = p_gl_class
    AND ic_gled_cls.delete_mark = 0;

Line: 1294

    SELECT
         fmeff_id
    FROM
         fm_form_eff
    WHERE
        fmeff_id  = p_fmeff_id
    AND delete_mark = 0;

Line: 1356

    SELECT
         resources
    FROM
         cr_rsrc_mst
    WHERE
        resources  = p_Resources
    AND delete_mark = 0;

Line: 1419

    SELECT
         rm.std_usage_um, um.um_type
    FROM
         sy_uoms_mst um, cr_rsrc_mst rm
    WHERE
        rm.resources  = p_Resources
    AND um.um_code    = rm.std_usage_um
    AND rm.delete_mark = 0;

Line: 1472

    SELECT
         Alloc_Id
    FROM
         gl_aloc_mst
    WHERE
        Alloc_Id  = p_Alloc_Id
    AND delete_mark = 0;

Line: 1532

    SELECT
         Alloc_id
    FROM
         gl_aloc_mst
    WHERE
        Alloc_Code	= p_Alloc_Code
    AND	Co_Code		= p_Co_Code
    AND delete_mark 	= 0;

Line: 1596

      SELECT segment_delimiter
      FROM   gl_plcy_mst
      WHERE  co_code = p_co_code
           AND delete_mark = 0;

Line: 1603

      SELECT COUNT(*)
      FROM   gl_plcy_seg
      WHERE  co_code = p_co_code
       AND   type = decode(ptype, '', type, ptype)
       AND   delete_mark = 0;

Line: 1663

    SELECT acctg_unit_desc
      INTO l_accu_desc
      FROM gl_accu_mst
     WHERE acctg_unit_no = l_acctg_unit
       AND co_code = p_co_code
       AND delete_mark = 0 ;

Line: 1670

    SELECT acct_desc
      INTO l_acct_desc
      FROM gl_acct_mst
     WHERE acct_no = l_acct_no
       AND co_code = p_co_code
       AND delete_mark = 0 ;

Line: 1722

    SELECT
         Um_Code
    FROM
         sy_uoms_mst
    WHERE
        Um_Code   = p_Usage_Um ;

Line: 1783

    SELECT
         Um_Type
    FROM
         sy_uoms_mst
    WHERE
        Um_Code   = p_Usage_Um ;

Line: 1836

  SELECT	cost_mthd_code
  FROM		cm_mthd_mst
  WHERE		cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
  AND		cm_mthd_mst.delete_mark    = 0
  AND		lot_actual_cost = 1;

Line: 1898

    SELECT	lot_id
    INTO	l_lot_id
    FROM   	ic_lots_mst
    WHERE	item_id = p_item_id
    AND		lot_no = p_lot_no
    AND		sublot_no = p_sublot_no
    AND		ROWNUM = 1;

Line: 1950

	SELECT	1
	INTO	l_cnt
	FROM	ic_lots_mst
	WHERE	item_id = p_item_id
        AND	lot_id = p_lot_id
	AND	ROWNUM = 1;

Line: 2007

	SELECT	1
	INTO	l_cnt
	FROM	ic_lots_mst
        WHERE	item_id = p_item_id
        AND	lot_no = p_lot_no
	AND	sublot_no = p_sublot_no
	AND	ROWNUM = 1;

Line: 2061

    SELECT      legal_entity_id
    FROM        xle_entity_profiles
    WHERE       legal_entity_id = p_legal_entity_id;

Line: 2120

    SELECT      cost_type_id
    FROM        cm_mthd_mst
    WHERE       cost_type_id = p_cost_type_id;

Line: 2181

    SELECT      cost_type_id
    FROM        cm_mthd_mst
    WHERE       cost_type_id = p_cost_type_id
    AND         (cost_type = decode(p_type, 'A', 1, 'S', 0, 'L', 6,'AS', 0) or cost_type = decode(p_type, 'A', 1, 'S', 0, 'L', 6, 'AS', 1));

Line: 2240

    SELECT      cost_type_id
    FROM        cm_mthd_mst
    WHERE       cost_mthd_code = p_cost_mthd_code;

Line: 2299

    SELECT      cost_type_id
    FROM        cm_mthd_mst
    WHERE       cost_mthd_code = p_cost_mthd_code
    AND         (cost_type = decode(p_type, 'A', 1, 'S', 0, 'L', 6,'AS', 0) or cost_type = decode(p_type, 'A', 1, 'S', 0, 'L', 6, 'AS', 1));

Line: 2359

    SELECT      period_id
    FROM        gmf_period_statuses
    WHERE       period_id = p_period_id;

Line: 2419

    SELECT      period_id, cost_type_id
    FROM        gmf_period_statuses
    WHERE       period_id = p_period_id;

Line: 2483

    SELECT      period_id
    FROM        gmf_period_statuses a,
                org_organization_definitions b
    WHERE       b.organization_id = p_organization_id
    AND         b.legal_entity = a.legal_entity_id
    AND         a.calendar_code = p_calendar_code
    AND         a.period_code = p_period_code
    AND         a.cost_type_id = p_cost_type_id;

Line: 2547

    SELECT      organization_id
    FROM        mtl_parameters
    WHERE       organization_id = p_organization_id
    AND         process_enabled_flag = 'Y';

Line: 2606

    SELECT      organization_id
    FROM        mtl_parameters
    WHERE       organization_code = p_organization_code;

Line: 2667

    SELECT      inventory_item_id
    FROM        mtl_system_items_b
    WHERE       inventory_item_id = p_inventory_item_id
    AND         organization_id = p_organization_id;

Line: 2728

    SELECT      inventory_item_id
    FROM        mtl_item_flexfields
    WHERE       item_number = p_item_number
    AND         organization_id = p_organization_id;

Line: 2792

    SELECT      lot_number
    FROM        mtl_lot_numbers
    WHERE       inventory_item_id = p_inventory_item_id
    AND         organization_id = p_organization_id
    AND         lot_number = p_lot_number;

Line: 2852

    SELECT	      cost_type_id
    FROM		      cm_mthd_mst
    WHERE		      cm_mthd_mst.cost_type_id = p_cost_type_id
    AND		        cm_mthd_mst.delete_mark    = 0
    AND		        cost_type = 6;

Line: 2907

    SELECT	      cost_type_id
    FROM		      cm_mthd_mst
    WHERE		      cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
    AND		        cm_mthd_mst.delete_mark    = 0
    AND		        cost_type = 6;

Line: 2961

       SELECT
            Alloc_id
       FROM
            gl_aloc_mst
       WHERE
           Alloc_Code	= p_Alloc_Code
       AND	legal_entity_id 	= p_le_id
       AND delete_mark 	= 0;

Line: 3024

       SELECT chart_of_accounts_id
       FROM  gmf_legal_entities
       WHERE legal_entity_id = p_le_id ;

Line: 3091

       SELECT code_combination_id
       FROM gl_code_combinations_kfv glc, gmf_legal_entities gle
       WHERE gle.legal_entity_id = p_le_id
             AND glc.code_combination_id = p_Basis_account_id
             AND gle.chart_of_accounts_id = glc.chart_of_accounts_id ;

Line: 3150

    SELECT  uom_code
    FROM mtl_units_of_measure
    WHERE uom_code = P_usgae_uom;

Line: 3209

  SELECT          c.uom_code
  FROM            mtl_system_items_b a,
                  mtl_units_of_measure b,
                  mtl_units_of_measure c
  WHERE           a.inventory_item_id = p_inventory_item_id
  AND             a.organization_id = p_organization_id
  AND             a.primary_uom_code = b.uom_code
  AND             b.uom_class = c.uom_class
  AND             c.uom_code= P_uom_code;

Line: 3267

  SELECT uom_class
  FROM mtl_units_of_measure
  WHERE uom_code = p_usage_uom;

Line: 3292

    SELECT
         rm.std_usage_uom, uom.uom_class
    FROM
         mtl_units_of_measure uom, cr_rsrc_mst rm
    WHERE
        rm.resources  = p_Resources
    AND uom.uom_code  = rm.std_usage_uom
    AND rm.delete_mark = 0;