APPS.WMS_COSTGROUPENGINE_PVT SQL Statements

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

Line: 169

	SELECT organization_id
	      ,to_subinventory_code
	      ,transaction_action_id
	      ,to_organization_id
	FROM wms_cost_groups_input_v
	WHERE line_id = p_line_id;

Line: 177

	SELECT fob_point
	  FROM MTL_INTERORG_PARAMETERS
	 WHERE from_organization_id = l_organization_id/*changed from l_source_organization_id for 3224420*/
	   AND to_organization_id = l_transfer_organization_id;

Line: 184

	SELECT count(object_name)
	FROM user_objects
	WHERE object_name = l_package_name;

Line: 190

       SELECT type_hdr_id
         FROM wms_rules_b
        WHERE rule_id = l_rule_id;

Line: 196

	SELECT default_cost_group_id
	  FROM mtl_secondary_inventories
	 WHERE secondary_inventory_name = l_to_subinventory_code
	   AND organization_id = l_organization_id;

Line: 204

	SELECT default_cost_group_id
	  FROM mtl_parameters
	 WHERE organization_id = l_organization_id;

Line: 268

         log_event(l_api_name, 'mmtt_line', 'Update a transaction with ' ||
  	        'transaction temp id: ' || p_line_id);

Line: 273

         log_event(l_api_name, 'mmtt_line', 'Update a move order with ' ||
		'move order line id: ' || p_line_id);

Line: 707

           UPDATE mtl_material_transactions_temp mmtt
              SET mmtt.transfer_cost_group_id = l_cost_group_id
            WHERE mmtt.transaction_temp_id = p_line_id;

Line: 713

           UPDATE mtl_material_transactions_temp mmtt
              SET mmtt.cost_group_id = l_cost_group_id
            WHERE mmtt.transaction_temp_id = p_line_id;

Line: 720

        UPDATE mtl_txn_request_lines mtrl
           SET mtrl.to_cost_group_id = l_cost_group_id
         WHERE mtrl.line_id = p_line_id;