APPS.GMF_CBOM_REP_PKG SQL Statements

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

Line: 46

	SELECT primary_uom_code into item_primary_uom
	 FROM mtl_system_items_b
	 WHERE inventory_item_id = p_invy_item_id
	  AND organization_id = p_organization_id ;

Line: 53

               SELECT product_qty, form_prod_uom into l_quantity, l_uom
                FROM cm_scst_led
                WHERE std_qty > 0
                  AND rownum < 2
                  AND cmpntcost_id in (SELECT cmpntcost_id
                                       FROM cm_cmpt_dtl
                                       WHERE inventory_item_id = p_prod_invy_item_id
                                         AND period_id = p_period_id
                                         AND cost_type_id = p_cost_type_id
                                         AND organization_id = p_organization_id
                                       ) ;

Line: 66

               SELECT item_fmqty, item_fmqty_uom INTO l_quantity, l_uom
                FROM cm_scst_led
                WHERE inventory_item_id = p_invy_item_id
                  AND rownum < 2
                  AND (line_type = -1  OR  line_type = 2)
                  AND cmpntcost_id in (select cmpntcost_id from cm_cmpt_dtl
                                       WHERE inventory_item_id = p_prod_invy_item_id
                                         AND period_id = p_period_id
                                         AND cost_type_id = p_cost_type_id
                                         AND organization_id = p_organization_id
                                       ) ;

Line: 129

    SELECT legal_entity_name INTO l_le_name FROM gmf_legal_entities
    WHERE legal_entity_id = p_le_id;

Line: 162

    SELECT base_currency_code INTO l_currency FROM gmf_legal_entities
    WHERE legal_entity_id = p_le_id;

Line: 196

     SELECT cost_mthd_code INTO l_cost_type FROM cm_mthd_mst
     WHERE cost_type_id = p_ct_id;

Line: 282

    SELECT period_id INTO l_period_id FROM gmf_period_statuses
    WHERE legal_entity_id = p_legal_entity_id
      AND calendar_code   = p_calendar_code
      AND period_code     = p_period_code
      AND cost_type_id    = p_cost_type_id;

Line: 314

    SELECT unique CONCATENATED_SEGMENTS INTO l_item
    FROM mtl_system_items_b_kfv where inventory_item_id = v_item_id;

Line: 346

   SELECT mc.concatenated_segments INTO l_category
   FROM mtl_default_category_sets mdc,
        mtl_category_sets mcs,
        mtl_categories_kfv mc
   WHERE mdc.functional_area_id = 19
     AND mdc.category_set_id = mcs.category_set_id
     AND mcs.structure_id = mc.structure_id
     AND mc.category_id = v_cat_id ;

Line: 385

     l_cat_where := ' AND EXISTS (SELECT mc.concatenated_segments ' ;